Register Discoverer Report in Oracle Applications

Steps for Register a Discoverer report in Oracle Apps. 

1. Login to Application Developer-->Function

2. Enter Function , User Function Name, Description(Optional) in Description Tab.
    E.g:

Query to find all Oracle Discoverer Reports/Workbooks

Run the following sequence of queries in APPS schema to find all Discoverer Reports/Workbooks that exist in the system.

Query1: Run the following query to know the name of table

SELECT owner,table_name
  FROM all_tables

Working with Discoverer Desktop - Part04

7. Building Worksheets and Workbooks

Your company's database administrator creates worksheets and workbooks based on your requirements for specific data analysis and reporting. However, while working with Discoverer Desktop, you may want to create additional worksheets and workbooks.