How to get Parent request id in oracle apps

Hi friends, we are going to discuss about how to get Parent request id in oracle apps. We will share the detail steps to find out the parent request id in oracle apps. In oracle apps, many concurrent requests itself submit the many child requests. We can say single concurrent program request itself fire many other child concurrent program requests. A good example , of this type of concurrent request is 'Create Accounting' program. 'Create Accounting' concurrent requests itself submit many other child concurrent requests. In this post, We will share the method to get the parent request id and the child request id in oracle apps. Please find below the complete detail about how to get Parent request id in oracle apps.

How to get Parent request id in oracle apps

Step by Step to get Parent request id in oracle apps

As we cannot get the parent request id directly from the application itself.we need to have some sql script which can helps to extract the parent and child concurrent request data from oracle apps application itself. Please find below more about on this.

Important Tables uses in the sql query to get parent request id in oracle apps

1.fnd_concurrent_requests
2.fnd_concurrent_requests
3.fnd_concurrent_programs
4.fnd_concurrent_programs_tl

SQL Script to get Parent request id in oracle apps

SELECT
fcr.request_id "Child Request ID",
PARENT_REQUEST_ID "Parent Request ID",
fcptl.user_concurrent_program_name"Parent Program Name",
fcr.phase_code,
fcr.status_code,
to_char(fcr.actual_start_date,'DD-MON-YYYY HH24:MI:SS') "Start Time",
(fcr.actual_completion_date - fcr.actual_start_date)*1440 "Elapsed"
FROM (SELECT
fcr1.request_id
FROM apps.fnd_concurrent_requests fcr1
WHERE 1=1
START WITH fcr1.request_id = :Parent_request_id
CONNECT BY PRIOR fcr1.request_id = fcr1.parent_request_id) x,
apps.fnd_concurrent_requests fcr,
apps.fnd_concurrent_programs fcp,
apps.fnd_concurrent_programs_tl fcptl
WHERE fcr.request_id = x.request_id
AND fcr.concurrent_program_id = fcp.concurrent_program_id
AND fcr.program_application_id = fcp.application_id
AND fcp.application_id = fcptl.application_id
AND fcp.concurrent_program_id = fcptl.concurrent_program_id
AND fcptl.language = 'US'
ORDER BY 1;

How to get Parent request id in oracle apps

How to get Parent request id in oracle apps