Tuesday 27 May 2008

Another Quick Reminder: Linking Discoverer Reports to standard Oracle Applications Menu

Here are the steps required to link a standard Discoverer workbook to an Oracle Applications menu:

Step

Description

Tool

1

Note the value of the workbook ‘Identifier’. Open the workbook, navigate to ‘File -> Manage Workbooks -> Properties.

Discoverer Plus

2

Create a new Form Function (Application -> Function). Required values:

Function: XX???_???

User Function Name: Report Name

Description: ???

Type: SSWA plsql function

Parameters: Workbook=Step 1 Identifier

HTML Call: OracleOasis.RunDiscoverer

System Administrator

3

Link the form function to the appropriate menu (Application -> Menu).

System Administrator

4

Share the business areas used by the workbook with the responsibilities associated with the modified menu

Discoverer Administrator

5

Share the workbook with the responsibilities associated with the modified menu

Discoverer Plus

Associated Profile Options:

Profile Name

Description

Value

ICX_DISCOVERER_USEVIEWER

Determines if Discoverer Viewer or Discoverer Plus is launched when a workbook is opened from a menu

Yes or No

References:

Metalink Note: 278095.1

No comments: