fnd_concurrent_requests status_code and phase_code meanings

fnd_concurrent_requests status_code and phase_code meanings

SQL> select lookup_code "lookup Code" ,meaning from apps.fnd_lookups where lookup_type='CP_STATUS_CODE';
lookup Code MEANING
 -------------------
 A          Waiting
 B          Resuming
 C          Normal
 D          Cancelled
 E          Error
 G          Warning
 H          On Hold
 I          Normal
 M          No Manager
 P          Scheduled
 Q          Standby
 R          Normal
 S          Suspended
 T          Terminating
 U          Disabled
 W          Paused
 X          Terminated
 Z          Waiting
18 rows selected.

SQL> select lookup_code "lookup Code" ,meaning from apps.fnd_lookups where lookup_type='CP_PHASE_CODE';
lookup Code MEANING
 ------------------
 C          Completed
 I          Inactive
 P          Pending
 R          Running

Scripts order by Category

      Database:

Alertlog Tail AWR Info Blocking Sessions Blocking Sessions1 DB Links DBA Directories DBA Directories Upd High Water Mark GSS Run Locked Objects Tablespace Free Database Info Database Consistency Resetlogs Time RMAN Sofar RMAN Sofar1 RMAN Status Sync Status on Prim Sync Status on DR User Undo Utl File Dir Wait Events DBA Files All DBA Tablespaces DML Locks DML Locks1 Long Operations Long Operations1 Resource Limit Role Privs DBMS Jobs Table Size Tablespace Usage Temp Extent Mapping Temp Free Temp Free1 Temp IO Temp Segments Temp Usage Temp Seg Usage Top CPU Tablespace Free TS Info Health of DB Temp Usage Invalids Jobs Total Jobs Running Max Extents PID Redo Per Hour Sessions Sessions1 Sessions User Sessions BG Sessions by CPU Sessions by Undo Sessions by Undo1 Sid Sid1 Undo UndoStatus User hit ratio User Privs User Temp Space

Concurrent Request (CR):

CR Details from Request ID CR Duration CRs Running Currently CRs Running Currently1

CR Pedning CR Pednig1 CR Pending on CRM CR Pending on CRM1 CR Pending on Internal Manager CR Pending on Stdmgr

CR Error in 24Hrs CRs Errorred Scheduled CRs

Oracle Applications Scripts:

cmclean

Oracle Applications Scripts

Description,Explanation, Execution and Sample Output	Download Script
Oracle Application Products Version	product_status.sql
Applications Relese/Version	release.sql
Patch applied or not?	patch.sql

Locks/Blocking Session Scripts

Description,Explanation, Execution and Sample Output	Download Script
Finding Blocking sessions	locks.sql
Objects currently Locked	locked_obj.sql

User Management Scripts

Description,Explanation, Execution and Sample Output	Download Script
Privilege associated with a User	user_privs.sql

Session Management Scripts

Description,Explanation, Execution and Sample Output	Download Script
Sql text running that is running by a Session with an SID	sql_text.sql
Session information from Process ID	pid.sql
Sessions currently connected to Database	sess_runnig.sql
Session information from Session ID (SID)	sid.sql

Database Info Scripts

Description,Explanation, Execution and Sample Output	Download Script
Database Information	db.sql
Check invalid objects	invalids.sql
Particular Table Size	tab_size.sql