List all concurrent requests in Oracle

Use the following query to list all the concurrent requests in Oracle which are in errored or error status.

Modify the query to get the reports that you want

select a.request_id,a.request_date,b.user_concurrent_program_name, a.requested_by,a.responsibility_application_id, a.responsibility_id,
a.completion_text, a.logfile_name from FND_CONCURRENT_REQUESTS a, FND_CONCURRENT_PROGRAMS_TL b where a.concurrent_program_id=b.concurrent_program_id
and  a.status_code='E' and a.request_date > to_date('13-jan-2008','DD-MON-YYYY') order by a.request_date desc