Status code and Phase code in fnd_concurrent_requests

Status code and Phase code in fnd_concurrent_requests

We always keep getting confused about the meanings of status_code and phase_code columns in fnd_concurrent_requests table. Here is the brief descriptions of statuses columns in the table.

Table name :-
FND_CONCURRENT_REQUESTS

Column name:-
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.

Column Name :-
PHASE_CODE.

C Completed
I Inactive
P Pending
R Running.

Query :-

SELECT status_code, phase_code
FROM fnd_concurrent_requests
WHERE request_id = :p_request_id