Discoverer with EBS in R12 (DISCOVERER REPORT REGISTRATION PROCESS)

* Navigate > System Administrator > Application > Function

* Go to the Description TAB

    * Enter Function Name =test_DWB

    * Enter User Function Name =TESTDISCO Function DWB

    * Enter Description = This Function Created to test discoverer 11g for R12.

We appended a suffix of “_DWB” at the end of the function name to indicate this is a Discoverer Workbook function. You may choose any other name for your function but it is a good idea to keep the function name same as the developer key for easy identification and tracking.

    * Now Go to the Properties TAB

    * Select Type = SSWA jsp function

    * Maintenance Mode Support = None

    * Context Dependence = Responsibility

* Now Go to Form TAB

   

* Enter Parameters =>  mode=DISCO

* Now Go to Web HTML TAB

   

* Enter HTML Call = OracleOasis.jsp and then Click on the Save Button

Now that we have created our Form Function we will create a new menu

“TESTDISCO” to hold this function.

Navigate > System Administrator > Application > Menus

Create a new menu “TESTDISCO”

Then attach the function to this menu “TESTDISCO Function DWB”

Prompt : “Test Discoverer Reports”

Save.

Now Attach this Menu to Responsibility.

Navigate > System Administrator > Security>Responsibility> Define

Responsibility Name:  Test Discoverer Reports

Application : Applications BIS  (for Example I used this).

(here you can use related application like (Payables, Purchasing, Assets, Human resource, etc).

Responsibility  Key :TESTDISCO

Menu : TESTDISCO  (attach here previously created).

SAVE.

Now you can add this Responsibility to the user.

Navigate > System Administrator > Security>User> Define

Before connecting to Oracle Discoverer as an Oracle Applications user, we must configure the Connect dialog to default to Oracle Applications users. Select Tools > Options to display the “Options dialog: Connection tab”.

To create an End User Layer in an Oracle database, the database user that the EUL is being created in must have the following database privileges:

      • CREATE SESSION

      • CREATE TABLE

      • CREATE VIEW

      • CREATE SEQUENCE

      • CREATE PROCEDURE