Oracle Technical

How to Create a Link to a Discoverer Workbook in Apps11i

How to Create a Link to a Discoverer Workbook in Apps11i

 To create a link from the Oracle Applications 11i home page to a Discoverer workbook that will automatically open Discoverer Plus or Viewer and display the workbook using apps security.

The basic process is:

1. Create the workbook.

2. Open the workbook in the Discoverer Desktop or Plus edition and go to
‘File->Manage Workbooks->Properties’ look for the value for ‘Identifier’. Save this value.

3. Create a form function. Open the Function form and create a new function.
Define the Form Function.
The form function definition includes the properties listed in these tabs:
3.1 Description tab:
3.1.1 Function Name: BIS_[X] (use something to distinguish it from seeded functions)
3.1.2 User Function Name: This is the name that will show in the menu
3.1.3 Description: Add a description of the function if you want.
3.2 Properties tab:
3.2.1 Type: Select “SSWA plsql function”
3.2.2 Maintenance Mode Support: Leave as “None”
3.2.3 Context Dependence: Leave as “Responsibility”
3.3 Form tab:
3.3.1 Form: Leave the field blank.
3.3.2 Application: Leave the field blank.
3.3.3 Parameters: workbook=<(workbook identifier from step2) &PARAMETERS=sheetid~worksheet id*param_parameter name One~Parameter One Value*param_parameter name Two~Parameter Two Value*

Eg; ‘workbook=TEST_WORKBOOK&PARAMETERS=sheetid~1*’  would open sheet 1 of the workbook.
3.4 Web HTML tab:
3.4.1 HTML call : Set as OracleOasis.RunDiscoverer
3.5 Web Host tab:
3.5.1 Leave all fields blank.
3.6 Region tab:
3.6.1 Leave all fields blank.
3.7 Save the form.

4. Open the menu form as sysadmin.
4.1 Search for the main menu under which you want the link to appear.
4.2 Add the information you need such as prompt, submenu, description etc.
4.3 Enter into the Function field the name of the function you created in step 3.
4.4 Save the menu form.

A message will appear saying that a concurrent program will run to regenerate the menus.
You can cancel it if you want and do step 5 below if the menu does not appear after the concurrent program runs.

5. Use adadmin and recompile the menu information to make the changes appear.
6. Bounce Apache and Forms.

References : For 10g, you can reference:  Oracle® Business Intelligence Discoverer Configuration Guide

Oracle Reports (Report 6i) – Technical – Interview – Question Answers

Receive the latest blog updates

Facebook Twitter Instagram Youtube Linkedin