How To Find All The Running Concurrent Requests And The Time Taken By Them

The below SQL query can be used for analyzing concurrent program run time and identifying their performances.

select request_id,

         fcpt.user_concurrent_program_name,

         completion_text,

         actual_start_date,

         actual_completion_date,

         to_date((actual_completion_date - actual_start_date), 'HH:MM:SS') duration

 from fnd_concurrent_requests fcr,

         fnd_concurrent_programs fcp,

         fnd_concurrent_programs_tl fcpt

where fcr.concurrent_program_id = fcp.concurrent_program_id

    and fcp.concurrent_program_id = fcpt.concurrent_program_id

    and fcr.actual_start_date > sysdate - 1

    order by actual_completion_date - actual_start_date desc

Other Important Articles Related To Concurrent Programs:

1. Different Concurrent Program Executable Methods In Oracle Apps
2. Meaning Of Different Status Codes And Phase Codes Used In Concurrent Programs
3. SQL Query To Find Scheduled Or On Hold Concurrent Request
4. SQL Query To Find Parameters and Value Sets Associated With A Concurrent Program
5. SQL Query To Find The Request Group Using An Executable | Important Apps Queries
6. SQL Script To Get Concurrent Program Details & Paraments