Find the responsibility name a concurrent program is attached with

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