Friday, February 23, 2024

How to move OTBI report from one instance to another?

Oracle Fusion has provided a feature to migrate OTBI reports from one Instance to another Instance. Source code migration is very easy process in Oracle fusion. Migration process helps in Cloud Implementation projects where we have to migrate hundreds of reports from one instance to another instance like from Dev instance to Prod instance. This is one of the great feature for OTBI reports migration.

Step1: Go to the OTBI Report which you want to migrate from one Instance to Another.

Step2: Select the OTBI Report.

Go to Source Instance(means from which instance you want to migrate)


Select report and click More. Click on 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.
Check both and click Ok


It will be saved. You can save this report in your local desktop.
Step 3: Go to the Target Instance in which we want to migrate this Report Source Code.

This is the Folder in which I want to upload these Reports Source.


Select folder and click Unarchive


Select the file which you saved the file on desktop and then click ok.

OTBI Report has been Upload in the Folder in the Target Instance.

Our OTBI report migration process has now completed and we can see the OTBI reports in Target Instance.




JS

RC