Oracle R12 – How to create a Menu Function to launch a concurrent request, request group and request set?

Oracle R12 – How to create a Menu Function to launch a concurrent request, request group and request set?

Business Need:

To run either a request/program or a request set or a request group using a menu option instead of selecting the view > request functionality.

1. Create a New Request Group:

Navigation:

System Administrator > Security > Responsibility > Request

Create a request group with multiple requests (can be standard / custom reports), here I have grouped 3 standard reports as a request group.

2. Create a Form Function:

Navigation:

System Administrator > Application > Function

Create a form function and define the required details as below.

 

3. Create a Menu Function:

Navigation:

System Administrator > Application > Menu

Create a Menu and attach the newly created Function to the Menu

4. Attach the Menu to the Responsibility:

Navigation:

System Administrator > Security > Responsibility > Define

Attach the newly created Menu to the Responsibility

5. Run the request/program or a request set or a request group using a menu option:

Navigate to the responsibility and click the Menu.

Now Submit a New Request form will be displayed, click the OK button and in the LOV the attached reports will be available.

Thus a request/program or a request set or a request group can be run using a menu option. 

Request Group and Request Set in Oracle R12

Short Notes on Request Group and Request Set

Request Groups and Request Sets:

• Reports and programs can be combined into Request group and Request Set.

• Request group is a collection of reports or concurrent programs. System Administrator defines report groups in order to control user access to reports and concurrent programs. Only a System Administrator can create a request group.

• Request Set define run and print options, and possibly, parameter values, for a collection of reports or concurrent program. End users and System Administrators can define request sets. System Administrator has request set privileges beyond those of an end user.

• Request security group defines the concurrent programs, including requests and request sets that may be run by an application user under a particular responsibility. When a request group is assigned to a responsibility, it becomes a request security group.

• You can run the same set of concurrent requests regularly by defining a request set and then submitting the request set from the Submit Request form. As System Administrator, you can include any Standard Request Submission report or concurrent program in the request sets you define. When end users define a request set, they can only select from reports and programs that belong to their responsibility’s request security group.

Individual Request and Request Sets

• Reports or concurrent programs that are not included in a request security group on an individual basis, but that do belong to a request set included in a request security group, have the following privileges:

• Users cannot use the Submit Requests form to run single requests and request sets that are not in their responsibility’s request security group.

• Users can, however, run request sets that contain requests that are not in their request security group, if the request set is in their request security group.