Query To Count Pending Request
SELECT
/*+ choose */ Count(*)
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs c,
fnd_conc_req_summary_v fcrv
WHERE fcr.concurrent_program_id = c.concurrent_program_id
AND fcr.program_application_id = c.application_id
AND fcr.concurrent_program_id = fcrv.concurrent_program_id
AND fcr.request_id = fcrv.request_id
AND fcrv.requested_start_date < SYSDATE + 10 / 1440
AND fcr.phase_code IN ( ‘P’ )
AND fcr.hold_flag != ‘Y’
Read More…
Query To find Concurrent Program Name, Phase Code And Status Code for a given Request ID
Query To Find a Concurrent Program Enabled with Trace
Query To Find Request Submitted By User
Query To Find Pending Request in Oracle Apps dba
Query To Find the Reports Finished With Error Code In Oracle Apps DBA
Terminating Report From Backend