Script to check for scheduled concurrent requests in Oracle Apps 11i

By
Jul 6, 2011
No Comments

Just a quick script that I wrote to report on concurrent requests that are scheduled to run in the future: select fcr.request_id, fcr.parent_request_id, fu.user_name requestor, to_char(fcr.requested_start_date, ‘MON-DD-YYYY HH24:MM:SS’) START_DATE, fr.responsibility_key responsibility, fcp.concurrent_program_name, fcpt.user_concurrent_program_name, 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 […]

Check for failed concurrent requests in Oracle EBS 11i

By
Jun 30, 2011
No Comments

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.