To check Conc Req Status

To check Conc Req Status :

set linesize 120
set pagesize 50
col phase_code for a20
col status_code for a20
select request_id,
decode(phase_code,'C','Completed','I','Inactive','P','Pending','R', 'Running ') PHASE_CODE,decode(status_code,
'A','Waiting','B','Resuming','C', 'Normal','D','Cancelled','E','Error','F','Scheduled','G','Warning',
'H','On Hold','I','Normal','M','No Manager','Q','Standby','R','Normal','S','Suspended','T','Terminating',
'U','Disabled','W','Paused','X','Terminated','Z','Waiting') STATUS_CODE from apps.fnd_concurrent_requests where request_id='&REQUESTID';

REQUEST_ID PHASE_CODE           STATUS_CODE
---------- -------------------- --------------------
    123456 Completed            Normal

UR's Key Run ;-)