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 ;-) 

Query to check d Code Levels Application Level

Query to check d Code Levels @ Application Level

Run


@$AD_TOP/sql/adutconf.sql

A file will be generated as adutconf.lst

Tip : If you r facing any issue in an upgraded instance and you would like to have exact data of difference @ Instance level, best way is to generate adutconf.lst in both upgraded and non-upgraded instances and compare.

UR's Key Run ;-)