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:
- Different Concurrent Program Executable Methods In Oracle Apps
- Meaning Of Different Status Codes And Phase Codes Used In Concurrent Programs
- SQL Query To Find Scheduled Or On Hold Concurrent Request
- SQL Query To Find Parameters and Value Sets Associated With A Concurrent Program
- SQL Query To Find The Request Group Using An Executable | Important Apps Queries
- SQL Script To Get Concurrent Program Details & Paraments
COMMENTS