We often come across a situation when we need to know the responsibility name through which we can submit a concurrent program. Unfortunately there is no standard way to find it out through front end. As a functional consultant you will need to be dependent on your DBA or someone who has back end access. In this busy world people will love you if you can give them the ready query that can do the trick. Query is not complex to built your own but it is the time you will save. So now on just pass on this query to find the responsibility name a concurrent program is attached with
Query to find the responsibility name a concurrent program is attached with
Select fcpt.user_concurrent_program_name “Concurrent Program Name”,
frg.request_group_name “Request Group Name”,
frt.responsibility_name “Responsibility Name”
From apps.fnd_Responsibility fr,
apps.fnd_responsibility_tl frt,
apps.fnd_request_groups frg,
apps.fnd_request_group_units frgu,
apps.fnd_concurrent_programs_tl fcpt
Where fcpt.user_concurrent_program_name = ‘iavinash.com Oracle HRMS and WordPress hub’ /* your program name goes here */
and fcpt.concurrent_program_id = frgu.request_unit_id
and frgu.request_group_id = frg.request_group_id
and frg.request_group_id = fr.request_group_id
and fr.responsibility_id = frt.responsibility_id
Order By 2
Further more, a concurrent program is not really linked to a responsibility but to a request group and eventually a request group is linked to responsibility. A responsibility can be linked with only one request group and same can be changed any point of time.
How to link a program with request group:
To link a program with request group we follow the navigation System Administrator » Security » Responsibility » Request
How to link a responsibility with request group:
To link a responsibility with request group we follow the navigation System Administrator » Security » Responsibility » Define
Additional Resource
You might also be interested to check the Oracle HRMS Technical Reference Manual also known as pertrm for more information on oracle seeded tables.