Discoverer reports are generally run from the Discoverer Viewer responsibility given to users. We can create a function on responsibilities so that the users can click on the link from the responsibilities page after logging in, to run the reports. We can add further restrictions on the function to allow the user access to certain reports only. I have illustrated the setup required for it below.
Step 1: Create a Form Function
Responsibility: System Administrator
Navigation: Application > Function
Enter the following
User Funtion Name: Invoke Web Discoverer
Description: XX Discoverer Reports on the OAF page
Click on Properties tab
Enter SS in Type
Select SSA jsp function
Click on Forms tab
Enter parameters: mode=DISCO
Click on Web HTML tab
Enter HTML call= OracleOasis.jsp
|Web HTML tab|
Save the function
Step 2: Add the function to a menu
Let’s take the menu for EY HR Letters responsibility.
Navigate to Security > Responsibility > Define
Query for EY HR Letters
Note the menu name: EY HR Letter Requests
Now let’s check the menu
Go to Application > Menu
Query for User Menu Name=EY HR Letter Requests
Let’s add a menu item for the form function we created above. The function name should be searched with the user function name.
On saving you will get a message for recompiling the menu
You can check the request status from View > Requests
|Compile menu request|
The setup is complete. It is better to bounce Apache so that the change is complete. You can view the post on bouncing Apache here.
3. Access the form function from the responsibility
Now let’s check the responsibility, EY HR Letters.
Notice the new menu Item, Discoverer Menu. Let’s take a closer look,
|Menu item on responsibility|
Clicking on this menu item will bring up the Discoverer viewer menu,
You will get access to all the reports that have been granted by the Discoverer administrator.
To restrict the form function to run only specific Discoverer reports
The administrator might want to restrict the menu item to a single report. It can be done at the form function itself. Let’s open the form function once more.
Open the function, XX_DISCO_FUN, and go to the form tab. Change the Parameters to, mode=DISCO&viewer=Y&workbook=EY_ANNUAL_LEAVE_TICKET_REPORT
Save the changes.
Go back the responsibility, EY HR Letters and click on the menu item, Discoverer Menu.
Previously this menu had access to the full list of discoverer reports. Now the same menu item has access to the EY_ANNUAL_LEAVE_TICKET_REPORT only. All menus with this function will be restricted to this report only. Therefore all responsibilities and in turn, the users, will be restricted to this report. To add more specific reports we can add more menu items similarly for other reports.