Applications maintains this type of information in FND_LOOKUPS view.

The following query would provide you the information regarding the 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
————
A -> Active
C -> Connecting
D -> Deactiviating
G -> Awaiting Discovery
K -> Terminated
M -> Migrating
P -> Suspended
R -> Running
S -> Deactivated
T -> Terminating
Z -> Initializing

Here are the status_codes for fnd_concurrent_requests and their meanings :-

PROCESS_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

PHASE_CODE
———–
C -> Completed
I -> Inactive
P -> Pending
R -> Running

Related Posts

• Number Of Total Completed Concurrent Request
• Oracle Concurrent Manager Process