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]
Thank you .. Resolved the issue...
Thanks for your query..
One more request.. If I want to know the details about failed concurrent program for last One hour.. how to tweak the above query....
replace sysdate-1 with sysdate - (1/24)