Latest
Home » Reusable Queries » Find the responsibility name a concurrent program is attached with
Find the responsibility name a concurrent program is attached with

Find the responsibility name a concurrent program is attached with

⚡ Must Read Fusion Article : Document of Record or Document Types in Fusion HCM

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.

☑ What to read next :
Question and answer forum of iavinash.com
☑ Related Job : Opening for HRMS Techno Functional – 1 year – Dubai

Check Also

OTL timecardtimesheet query to fetch submittedapproved hours

OTL timecard/timesheet query to fetch submitted/approved hours

OTL Query Here is the query to get time submitted by any resource (employee as …