Here in this post we
will see how to use the SQL to identify to which responsibility a concurrent
program is attached to in Oracle e-Business Suite.
Query 1
---To Find the
EXECUTABLE NAME
SELECT EXECUTABLE_ID, EXECUTABLE_NAME
FROM
FND_EXECUTABLES_FORM_V
WHERE
EXECUTION_FILE_NAME =<<Execution_File_Name>>;
Query 2
---To Find the
CONCURRENT PROGRAM NAME for EXECUTABLE_ID found in Query 1
SELECT USER_CONCURRENT_PROGRAM_NAME
FROM
FND_CONCURRENT_PROGRAMS_VL
WHERE
EXECUTABLE_ID =<<Executable ID from query 1>>;
Query 3
--- To Find the
REQUEST GROUP of the concurrent program found in query 2
SELECT *
FROM
fnd_concurrent_programs_tl
WHERE
user_concurrent_program_name LIKE <<User Concurrent Program name from Query
2>>;
Query 4
--- To Find the
REQUEST GROUP ID of the Concurrent Program found in query 3
SELECT REQUEST_GROUP_ID, REQUEST_GROUP_NAME
FROM
fnd_request_groups
WHERE
request_group_id IN (SELECT request_group_id
FROM
fnd_request_group_units
WHERE
request_unit_id =(<<Concurrent program ID found from Query 3>>);
Query 5
---To Find the
RESPONSIBILITY NAME
SELECT RESPONSIBILITY_NAME
FROM
FND_RESPONSIBILITY_VL
WHERE
request_group_id =<<Request Group ID from Query 4>>;
For any suggestions or issues
with the above code, please leave your comments. I will try to reply back as
soon as possible
