How to Export and Import a Workbook in Oracle Discoverer

You can export workbooks from one instance to another instance in Oracle Discoverer.

Follow the below steps

Step 1:

Login to Oracle Discoverer Administrator.

Step 2:

Go to File>>Export>>

Export wizard will be appeared

 

Step 3:

Mark ‘Selected Objects in the End user Layer’ from the Wizard and Click on Next

 

 

Step 4:

Select the workbook/S you need to migrate and click on next .

 

 

Step 5 :

Provide the file name and location to save the file and click on Finish

 

 

Now the Exported Workbooks are ready to import to destination with extension *.eex

 

Step 6:

Login to Discoverer administrator of your destination instance .

Go to File>>Import

Select the *.eex file from the location you have saved by pressing on Add file button from the Wizard.

Click on next

 

Step 7:

Keep the default selections as it is and click on Next

 

 

Step 8 :

Click on Start button

 

 

Once the import is completed click on finish.

Note: Check for the Timestamp from DB

Execute below select statement from DB (Both Prod and UAT)

SELECT VER_EUL_TIMESTAMP FROM eul5_us.eul5_versions;

If the output is same for the instance execute below statement.

UPDATE EUL5_VERSIONS

SET VER_EUL_TIMESTAMP = TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS');

Else ignore the above statement.