Attach Concurrent Program / Request Set to Request Group

Attach Concurrent Program / Request Set to Request Group


1. Find the Request Group of the Responsibility
Responsibility: System Administrator
Navigation: Security > Responsibility > Define



Search for the Responsibility with which the Concurrent Program needs to be run. Copy the request group name.



2. Attach the Concurrent Program/Request Set to the Request Group
Responsibility: System Administrator
Navigation: Security > Responsibility > Request

Search the request Group name for attaching the concurrent Program



Attach the Concurrent Program or Request Set to this Request Group.



Once attached, the Concurrent Program/Request Set can be run from given responsibility from the SRS.

Query

The main query joins Concurrent Program table or Request Set table and Request Group table with the help of Request Group Units as the intermediate table. The Request Group table is finally joined with the Responsibility table. Below are the main tables used:

FND_REQUEST_GROUPS
FND_REQUEST_GROUP_UNITS
FND_CONCURRENT_PROGRAMS (For Concurrent Program)
FND_CONCURRENT_PROGRAMS_TL (For Concurrent Program)
FND_REQUEST_SETS_TL (For Request Set)
FND_REQUEST_SETS (For Request Set)
FND_RESPONSIBILITY_TL
FND_RESPONSIBILITY

The main queries take the final shape as below:

Concurrent Program
select fcpt.user_concurrent_program_name ,fcp.concurrent_program_name program_short_name ,frt.responsibility_name ,frg.request_group_name from fnd_request_groups frg ,fnd_request_group_units frgu ,fnd_concurrent_programs fcp ,fnd_concurrent_programs_tl fcpt ,fnd_responsibility_tl frt ,fnd_responsibility frs where frgu.unit_application_id = fcp.application_id and frgu.request_unit_id = fcp.concurrent_program_id and frg.request_group_id = frgu.request_group_id and frg.application_id = frgu.application_id and fcpt.language='US' and fcp.application_id = fcpt.application_id and fcp.concurrent_program_id = fcpt.concurrent_program_id and frs.application_id = frt.application_id and frs.responsibility_id = frt.responsibility_id and frt.language='US' and frs.request_group_id = frg.request_group_id and frs.application_id = frg.application_id and fcp.concurrent_program_name = nvl(:concurrent_program_name,fcp.concurrent_program_name) and fcpt.user_concurrent_program_name =nvl(:user_concurrent_program_name ,fcpt.user_concurrent_program_name) order by fcpt.user_concurrent_program_name;


Request Set
select frst.user_request_set_name ,frt.responsibility_name ,frg.request_group_name from apps.fnd_request_sets_tl frst ,apps.fnd_request_sets frs ,fnd_request_group_units frgu ,fnd_request_groups frg ,fnd_responsibility_tl frt ,fnd_responsibility fr where 1=1 and fr.application_id = frt.application_id and fr.responsibility_id = frt.responsibility_id and frt.language = 'US' and fr.request_group_id = frg.request_group_id and fr.application_id = frg.application_id and frg.request_group_id = frgu.request_group_id and frg.application_id = frgu.application_id and frgu.unit_application_id = frs.application_id and frgu.request_unit_id=frs.request_set_id and frs.request_set_id=frst.request_set_id and frst.language='US' and frst.user_request_set_name= :user_request_set_name order by frst.user_request_set_name;