Wednesday, September 17, 2008

Status code and Phase code for Concurrent requests

Here is what the abbreviation for status code and phase code means for Concurrent Requests in Oracle Apps

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 column

C Completed
I Inactive
P Pending
R Running

 

Thus a request in "Running" "Normal" state will have phase_code "R" and status_code"R"

5 comments:

Shankar Ganesh said...

CP_STATUS_CODE & CP_PHASE_CODE are the lookup_types in the fnd_lookup_values table.

Himanshu said...

thanks for the information...

Anonymous said...

Thank you so much!

Anonymous said...

always refer ur blog...nice one

nilesh

Anonymous said...

life saver!