How to Convert Oracle Discoverer reports to BI Publisher reports

 Below are the details about how we can convert the oracle discoverer reports to BI Publisher reports.

1. Login to Oracle Discoverer with the corresponding user details and request the Administrator to assign the required responsibilities needed to view the reports.

2.After the login page you will be directed to select responsibility page where you need to select the responsibility and click on continue button.

3.Click on browse button below to search the report

4.You will find the list of all the reports ,select any report and click on open button

5.You will find the parameter list if the report has parameters, select the values in the parameters and the report will run and produce output

6.Now click on Tools Menu -> Show SQL to get the query written behind the report.

7.Copy the SQL Query , for additional conditions or calculations there are tab pages under available items on top left, you can verify for all those conditions.

8.Now create data xml with the same parameter list as you have seen above and use the query to create select statement in your data xml for BI Publisher report. Add the additional conditions noted in above steps to this select statement and also you can add the conditions.

9.As the Oracle discoverers are excel outputs, you can either build excel layouts or PDF layouts based on the requirement.