Query To Find Pending Request in Oracle Apps dba.
SELECT request_id, id,
Nvl(meaning, ‘UNKNOWN’) status,
user_concurrent_program_name pname,
To_char(request_date, ‘DD-MON-RR HH24:MI:SS’) submitd
FROM fnd_concurrent_requests fcr,
fnd_lookups fl,
fnd_concurrent_programs_vl fcpv
WHERE phase_code = ‘P’
AND hold_flag = ‘Y’
AND fcr.requested_start_date <= SYSDATE
AND status_code != ‘P’
AND lookup_type = ‘CP_STATUS_CODE’
AND lookup_code = status_code
AND fcr.concurrent_program_id = fcpv.concurrent_program_id
AND fcr.program_application_id = fcpv.application_id
ORDER BY request_date,
request_id;
Read More Oracle Apps Scripts:
Query To Find the Reports Finished With Error Code In Oracle Apps DBA
Terminating Report From Backend