How to Migrate the Reports Source Code from One Instance to Another in Oracle Fusion

How to Migrate the Report Source Code from One Instance to Another in Oracle Fusion

Source code migration is very important steps when we are doing the development. We need to move the source code from Development to Production instance once this is freeze. In Oracle Apps r12 , We uses different approach to migrate the reports source from Test to Production. Because we develops the reports outside the application then upload that code in the application later on But in Oracle Fusion , As I said in previous posts , Reports tool is integrated inside the fusion application and we design the reports under the application so we have different strategy to migrate the reports source from Test to Production.

 

As I said , Oracle Fusion BIP reports has two parts and two developed any BIP report we need to develop both these two parts step by step like below

1.BIP Reports Data Model

2.BIP Report (Reports Template Part)

 

First we create the Data Model , In which we write the SQL query for the BIP reports. In the Data Model we writes the SQL query and create the reports group and parameters as per our Requirment and then save this Data Model.

 

Second Once the Data Model create then We create the report on the Basis of this created Data Model. In this Report creation , We deign the Layouts of the Report based on the Data Model.

To Identify the Report and Data Model Object in the Oracle Fusion we need to follow these below signs

For Data Model : Highlighted one is the Data Model sign

For BIP Reports : Highlighted one is the Report sign

 



Steps to Migrate the Reports Source Code from One Instance to Another in Oracle Fusion

Step1:- Go to the Report which you want to migrate from one Instance to Another As I said reports have two parts(Data Model & Report) so we need to migrate both these one by one.

 

Step2:- This is the Report which I want to migrate.

 

Click on More ==> Archive

 

Step3:- After Archive , System will ask these below options that if you want to keep same permissions like this instance then you should check this checkbox. like the same for Timestamps.

Click ok.

Step4:- As below you can save this report in your local desktop.

Step5:- Follow the Same steps from Step2 to Step 4 for Report Data Model.

Step6:- Now you have downloaded the BIP report (Data Model & Report) objects in your local desktop and the next step to upload these objects in the Target Instance.


Step7:- Go to the Target Instance in which we want to migrate this Report Source Code.

Step8:- As below this is the Folder in which I want to upload these Reports Source.

Click on the Folder Name in the Left hand Side.

In the Tasks Pan, You will see the Highlighted 'Unarchive' option. Click on that that.

 Step9:- Unarchive will give you this option.
Click on the Browse and select the Report Source code from your Local Desktop.

Step10:- Select these code one by one from your Local Desktop.

Step11:- As below selected the Report Data Model and Click OK.

Step12:- As below , Report Data Model has been Upload in the Temp Folder in the Target Instance.

In the Same way migrate the second object of the Report and complete the Migration Process.

If you want to Learn Oracle Fusion Online then Refer this complete Oracle Fusion Tutorial