7.Deploying Discoverer Report into Oracle Apps.

After done with creating discoverer report make a note of workbook name and below  are the steps to register a discoverer report in Oracle Apps.

Make sure you followed each and every one correctly.

1. Go to Application Developer-->Function

2. Enter Function , User Function Name, Description(Optional) in Description Tab.
Ex:Function: TEST_DISCO
User Function Name: Discoverer Report
Description: Discoverer Report

3 In Properties Tab
Select Type “SSWA plsql function”
Maintenance Mode Support – None
Context Dependence - Responsibility

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

EX: Workbook=TEST_WORKBOOK
In case you want to give some parameters then you can use:
workbook=&parameters=~*~*~*
Example:
workbook=&Parameters=age~26*salary~ 1000*

5. In Web HTML Tab

Enter HTML Call - OracleOasis.RunDiscoverer

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://:/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.