Discoverer Report Registration in Oracle Applications

The following are the steps,to register a discoverer report in Oracle Apps. Make sure you followed each and every step correctly.

1. Login to Application Developer or System Adminstrator -->Function

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

E.g
Function: UNPAID_INVOICES
User Function Name: Supplier Invoices Validated But not unpaid.
Description: Give meaningful meaning.

In Properties Tab:

Select Type “SSWA jsp function”
Maintenance Mode Support – None
Context Dependence - Responsibility


4. In Form Tab  Parameters --> Enter the Workbook name created previously

mode=DISCO&workbook= Supplier Invoices Validated But Unpaid Report(workbook name you created in discoverer desktop)

E.g
workbook=TEST_WORKBOOK
In case you want to give some parameters then you can use:
workbook=<workbook_name>&parameters=<Parameter_nam e1>~<value1>*<Parameter_name2>~<value2>*<Parameter _name3>~<value3>*Example
workbook=<workbook_name>&Parameters=age~26*salary~ 1000*

5. In Web HTML Tab

Enter HTML Call - OracleOasis.jsp

6. Now you can add this Function in any existing or new Menu

Also Note that Discoverer Report cannot be invoked when you’ve direct login into Oracle Applications through http://<url>:<port number>/dev60cgi/f60cgi
You need to access through logging in from the browser web page. Otherwise it will give an Error.

7. Now navigate to Responsibility which contain the Menu to which you added this function.

8. Click the Function Name to Display the report.

Challa.