Hi All,
We execute very frequently SQL on the table – FND_CONCURRENT_REQUESTS to get the details on the Concurrent details to analysis and know the parameters and other details but not sure if we actually have details on all Status Codes and Phase Codes getting used in the table – FND_CONCURRENT_REQUESTS
MEANING FOR THE PHASE_CODE COLUMN VALUES:
C Completed
I Inactive
P Pending
R Running
MEANING FOR THE STATUS_CODE COLUMN VALUES:
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
Meaning of Status Codes and Phase Code in Fnd Conncurent Request table – FND_CONCURRENT_REQUESTS
Related posts:
SQL Query to check if AP invoices is posted or not
Oracle Apps R12 Account Receivables (AR) Transaction Type Setup
SQL query to find out the concurrent programs attaching to a plsql package
Create Request Groups in Oracle Apps for submission of Concurrent Programs
SQL to get the Invoice Status in Account Payables
Oracle apps AR Receipt status
Oracle Apps DBA SQL Query To get On Hold Concurrent Request in Oracle Apps R12
Work Manager pre defined request classes in WebLogic Server