Check for failed concurrent requests in Oracle EBS 11i
Just a quick SQL script that I wrote to check for concurrent requests that failed in the past 24 hours. The script is for E-Business Suite 11.5.10.2; it may or may not work on other versions of Oracle Apps.
select fcr.request_id, fcr.parent_request_id, fu.user_name requestor, to_char(fcr.last_update_date, 'MON-DD-YYYY HH24:MM:SS') LAST_UPDATE, fr.responsibility_key responsibility, fcp.concurrent_program_name, fcpt.user_concurrent_program_name, fcr.argument_text, decode(fcr.status_code, 'A', 'Waiting', 'B', 'Resuming', 'C', 'Normal', 'D', 'Cancelled', 'E', 'Error', 'F', 'Scheduled', 'G', 'Warning', 'H', 'On Hold', 'I', 'Normal', 'M', 'No Manager', 'Q', 'Standby', 'R', 'Normal', 'S', 'Suspended', 'T', 'Terminating', 'U', 'Disabled', 'W', 'Paused', 'X', 'Terminated', 'Z', 'Waiting') status, decode(fcr.phase_code, 'C', 'Completed', 'I', 'Inactive', 'P', 'Pending', 'R', 'Running') phase, fcr.completion_text from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt, fnd_user fu, fnd_responsibility fr where fcr.status_code in ('D', 'E', 'S', 'T', 'X') and fcr.phase_code = 'C' and fcr.last_update_date > sysdate - 1 and fu.user_id = fcr.requested_by and fcr.concurrent_program_id = fcp.concurrent_program_id and fcr.concurrent_program_id = fcpt.concurrent_program_id and fcr.responsibility_id = fr.responsibility_id order by fcr.last_update_date, fcr.request_id;
References
Recent Comments