Add/modify as needed
from fnd_lookups fl
where fcr.status_code = fl.lookup_code
and fl.lookup_type = 'CP_STATUS_CODE'
from fnd_concurrent_programs_vl fcpv
, fnd_concurrent_requests fcr
where fcpv.concurrent_program_id = fcr.concurrent_program_id
and fcr.status_code in ( 'E','G') --error and warning
and fcr.actual_completion_date >= sysdate - 1
Can you please suggest how can I get the information for failed concurrent program for last 24 hours?
Concurrent Processing - What are the Meaning of the Codes in the STATUS_CODE and PHASE_CODE Columns of FND_CONCURRENT_REQUESTS Table? [ID 152209.1]