Registering Discoverer Report in Oracle APPS

1. Create a Business Area and the required folders using Discoverer Administration

edition.

2. Give the access of the Business Area to the required Apps responsibilities and

Users. For doing this the navigation is

• In Discoverer Administration edition: Navigate to Tools Security and

give the permission to the necessary responsibilities and users.

• For giving different privileges on the business area Navigate to

Tools Privileges and assign the necessary privilege to the reqd.

responsibility/user.

Note: For creating Workbooks the Create Workbook privilege should be

given.

3. Logon to the Discoverer and create the workbook using the Discoverer Desktop

edition. The user/responsibility should be one in the list of Users/Responsibilities

that are given permission for accessing the Business Area and privileged to create

workbooks on that business area (as mentioned in Step 2). Save the workbook in

the database with a name, say EMPLOYEES.

4. Logon to the Application Application Developer responsibility Functions

Screen.

In Functions screen the following are the values that have to be given

1 Function Name: Give the name of the Function, say EMPLOYEE_TEST_FN

2 User Function Name: Give any descriptive Name, say Employee Discoverer Report

3 Description: Same as in User Function Name Field

4 Type: Give the type as SSWA plsql function (Self Service Web Application).

5 Maintenance Mode Support: NONE

6 Context Dependence: Responsibility

7 Form: Leave Blank

8 Application: Leave Blank

9 Parameters: WORKBOOK=, in our case WORKBOOK=EMPLOYEES

10 HTML Call: OracleOasis.RunDiscoverer

11 MDS Reference Path: Leave Blank

12 Host Name, Agent Name, Icon: Leave Blank

13 Object, Region Application, Region Code: Leave Blank

5. Add this Function to any Self Service responsibility and run the report.