Query To Find All Reports Status With User Name
SELECT /*+ choose */ U.user_name User_name,
fcr.request_id, request_id,
To_char(Round(( Nvl(fcr.actual_completion_date,
SYSDATE) –
fcr.actual_start_date ) *
1440)) TIME,
c.concurrent_program_name
|| ‘ – ‘
|| Substr(fcrv.program, 1, 45) PROGRAM,
fcr.concurrent_program_id,Program_id,
fcr.parent_request_id
Parent_id,
To_char(fcrv.requested_start_date, ‘DD-MON-RR HH24:MI’) Scheduled,
Decode(fcr.phase_code, ‘C’, ‘Completed’,
‘I’, ‘Inactive’,
‘P’, ‘Pending’,
‘R’, ‘Running’)
|| ‘ – ‘
|| Decode(fcr.status_code, ‘A’, ‘Waiting’,
‘B’, ‘Resuming’,
‘C’, ‘Normal’,
‘D’, ‘Cancelled’,
‘E’, ‘Error’,
‘G’, ‘Warning’,
‘H’, ‘On Hold’,
‘I’, ‘Normal’,
‘M’, ‘No Manager’,
‘P’, ‘Scheduled’,
‘Q’, ‘Standby’,
‘R’, ‘Normal’,
‘S’, ‘Suspended’,
‘T’, ‘Terminating’,
‘U’, ‘Disabled’,
‘W’, ‘Paused’,
‘X’, ‘Terminated’,
‘Z’, ‘ Waiting’) Status
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs c,
fnd_conc_req_summary_v fcrv,
fnd_user U
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’
AND fcr.requested_by = U.user_id
ORDER BY 1,
2 ASC
Read More…
Query To Count Pending Request
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