How To Find the Meanings of Various Status Codes

Goal:

How to interpret the different status_codes for fnd_concurrent_requests and various process_status_codes for fnd_concurrent_processes.

SOLUTION :

Applications maintains this type of information in FND_LOOKUPS view.

The following query would provide you the information regarding the process_status_code and its meaning for fnd_concurrent_processes.

SQL>select lookup_code, meaning from fnd_lookups where lookup_type ='CP_PROCESS_STATUS_CODE'

LOOKUP_CODE         MEANING

------------                    ---------

A                              Active

C                              Connecting

D                              Deactivating

G                              Awaiting Discovery

K                              Terminated

M                              Migrating

P                              Suspended

R                              Running

S                              Deactivated

T                              Terminating

Z                              Initializing

The following query would provide you the information regarding the status_code and its meaning for fnd_concurrent_requests.

SQL> select lookup_code, meaning from fnd_lookups where lookup_type ='CP_STATUS_CODE';

PROCESS_STATUS_CODE Column:  

~~~~~~~~~~~~~~~~~~~~~~~~~~~

    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  

Phase code is also returned from FND_LOOKUPS where the lookup_type is 'CP_PHASE_CODE'

PHASE_CODE column

-----------------

    C Completed

    I Inactive

    P Pending

    R Running

+++++++ID 297909.1+++++++