Register Discoverer Report in Oracle Apps R12

[Nirmal Chotaliya]

Steps to Register Discoverer Report In R12

 

1. Discoverer Desktop

 

Create the workbook.

 

2. Discoverer Desktop

 

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.

 

Other thing you have to tack care is sharing workbook to User/Responsibility for that go to

‘File -> Manage Workbooks -> Sharing and share workbook to User/Responsibility.

 

3. Oracle Apps R12

 

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:

 

Description tab:

3.1.1 Function Name: XX_[FUNCTION_NAME] (it is accepted practice to identify customizations with an XX prefix)

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.

 

Properties tab:

3.2.1 Type : SSWA jsp function   ---- Note : This HTML call is different then R11i ‘ SSWA PlSql Function ’

3.2.2 Maintenance Mode Support: Leave as "None"

3.2.3 Context Dependence: Leave as "Responsibility"

 

Form tab:

3.3.1 Form: Leave the field blank.

3.3.2 Application: Leave the field blank.

3.3.3 Parameters : mode=DISCO&workbook=<workbook identifier from step2>&parameters=Disco parameter name M~Parameter M Value*param_Workbook parameter name N~Parameter N Value*...

 

# According to the Applications Administration Edition, the workbook name will also work here.

 

Web HTML tab:

3.4.1 HTML call : OracleOasis.jsp  ---- Note : This HTML call is different then R11i  OracleOasis.RunDiscoverer

 

Web Host tab:

3.5.1 Leave all fields blank.

 

Region tab:

3.6.1 Leave all fields blank.

 

Save the form.

 

4. Oracle Apps R12

 

Open the menu form.

 

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 - This is optional Part

 

Also one point to note is that the Work Book Name passed in the Function Parameter should be the Identifier or Internal Name.

Please note that this is NOT the workbook name.

Regards,

Nirmal Chotaliya