Query to get concurrent program run details in oracle apps

Query to get concurrent program run details in oracle apps

In this post , We will be able to discuss about query to get concurrent program run details in oracle apps. This sql query will help to extract the list of concurrent program running details in oracle apps. We will be able to get the concurrent request run history details using this query.Here below is the query to get concurrent program run details in oracle apps.

Important  tables Used by Query to get concurrent program run details in oracle apps

1.fnd_concurrent_requests

2.fnd_concurrent_programs

3.FND_CONCURRENT_PROGRAMS_TL 

4.fnd_user

Query to get concurrent program run details in oracle apps

Here below is the detail sql query to get concurrent program run details in oracle apps

SELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME,

 round(((sysdate-a.actual_start_date)*24*60*60/60),2) AS Process_time,

 a.request_id,a.parent_request_id,

 a.request_date,

 a.actual_start_date,

 a.actual_completion_date,

 (a.actual_completion_date-a.request_date)*24*60*60 AS end_to_end,

 (a.actual_start_date-a.request_date)*24*60*60 AS lag_time,

 d.user_name,

 a.phase_code,

 a.status_code,

 a.argument_text,

 a.priority

FROM   apps.fnd_concurrent_requests a,apps.fnd_concurrent_programs b,apps.FND_CONCURRENT_PROGRAMS_TL c,apps.fnd_user d

WHERE  a.concurrent_program_id=b.concurrent_program_id

AND b.concurrent_program_id=c.concurrent_program_id

AND a.requested_by=d.user_id 

--AND status_code='R'  --USE THIS CONDITION IF YOU WANT TO SEE ONLY RUNNING REQUESTS--

order by Process_time desc;