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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s