Oracle Fusion BIP Report :How to Download/Save the Reports Source Code in Oracle Fusion

How to Download/Save the Reports Source Code in Oracle Fusion

In oracle fusion , We do Create and designs the Reports in the Application itself. It means Reports tools are integrated in the Oracle Fusion Application itself. So when we design the Reports then system automatically saves the reports source code inside the Oracle Fusion application. Here below I will share the method and more detail information about Oracle Fusion Reports backup.

 

Oracle Fusion BIP Reports are Divided in two Parts

When we create the Oracle Fusion BIP reports We need to Design these reports in Two Part and that is as below :

1.BIP Reports Data Model

2.BIP Report (Template)

 

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.

 

So now I will start to discuss about how to Download/Save the Reports Source Code in Oracle Fusion

 

Two Important Points to Download/Save the Reports Source Code in Oracle Fusion

1. Archive

2.Unarchive

 

Steps to Download/Save the Reports Source Code in Oracle Fusion

Step1:- Go to Reports and Analytics where our reports usually Stores.

Login to Oracle Fusion and go to Menu Navigator as below and Click on Reports and Analysis option.

 

Step2:- Go to the Desired Folder Path in which your reports has created in Oracle Fusion Reports.

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.

 

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

 

Click on More ==> Archive

 

 2:- 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.

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

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

 5:- 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.

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