Monitoring Failed Concurrent Programs - Oracle Applications

The following script finds all concurrent requests which are failed from the Date specified to the script. This provides log file location also.

  SELECT fcr.request_id,

         fu.user_name,

         fcp.user_concurrent_program_name,

         TO_CHAR (fcr.actual_start_date, 'DD-MON-YYYY HH24:MI:SS') actual_start_date,

         TO_CHAR (fcr.actual_completion_date, 'DD-MON-YYYY HH24:MI:SS') actual_completion_date,

         fcr.logfile_name

    FROM apps.fnd_concurrent_requests fcr,

         apps.fnd_concurrent_programs_tl fcp,

         apps.fnd_user fu

   WHERE     fcr.program_application_id = fcp.application_id

         AND fcr.concurrent_program_id = fcp.concurrent_program_id

         AND fcr.requested_by = fu.user_id

         AND fcr.phase_code = 'C'

         AND fcr.status_code = 'E'

         AND fcr.actual_completion_date > to_date('&Enter_Date','DD-MON-YYYY')

         AND fcp.user_concurrent_program_name NOT IN

                ('Request Set Stage', 'Report Set')

ORDER BY 1