Friday 22 May 2015

Request Set and Request Group in Oracle Apps

    Request Set is the collection of concurrent programs which executes in sequential/parallel manner which you have defined from a single transaction. Request Sets also has run and/or print options which apply to every concurrent program defined. The programs in the request set can share the parameters, Hence Parameter values need to be entered only once for multiple programs.

     Request group is a collection of reports or concurrent programs. It may be individual concurrent program or Request Sets. Request groups are normally associated with Responsibility. Request Groups can be used to implement the security at responsibility level.

Request Set Creation: 

1) Go to System Administrator Responsibility=>Requests=>Set










Request Set window will be opened.










2) Enter the Set name.
3) Enter the set code.
4) Select the application from the LOV.
5) Enter the description about the Request Set.
6) You can select the owner of that request set. This is optional.
7) You can mention the active Dates and select the Run Options.
8) Either you can go for Request Set Wizard or manually define the stages.
9) Click on Define Stages.
















10) Define the sequence of the stage.
11) Enter the Stage name and stage code.
12) Click on Requests button.
















13) Enter the sequence and select the program name. Here you can define multiple programs or single program.
14) You can manage the Parameters from Request Parameter window.










15) You can manage the stages from Link stage window.










Request Group Creation:

1) Go to System Administrator Responsibility =>Security=>Responsibility =>Requests.












Request Groups window will be opened.










1) Enter the Request Group Name.
2) Select the Application from the LOV.
3) Code is the optional field.
4) Enter the description for that Request group.
5) Go to the detail block.
6) Select the Type as program /Set.
7) Select the concurrent program name/Request Set name from the LOV.
8) Click on Save.
9) For verification open the request group window =>Press F11=>Enter the Request Group Name =>ctrl+F11.

10) You can also check the request group information from back end.

The table fnd_request_groups provides the header information of request group.


The Table FND_REQUEST_GROUP_UNITS provides the concurrent program details which are attached to the request group.


How to Run Request Sets:

As discussed the request group is associated with the Responsibility. Find the Responsibility to which the request group is attached.
1) Go to System Administrator => Responsibility=> Define
2) Press F11 and enter the Request Group name and press ctrl+F11.
3) It will show the responsibility where this Request Group has been attached.












4) Login to that responsibility Go to View menu=>Requests
5) Click on Submit New Request button
6) By Default Single request will be selected. Change that to Request Set and click on OK.




















7) Select the request set name from the LOV . It will show all the concurrent programs defined in that set. Select the Parameter and click on Submit.

No comments: