El fin del siguiente post es mostrarles que significan los códigos de estado de la tabla de concurrentes "fnd_concurrent_worker_requests"
Columna 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
Ccolumna PHASE_CODE
C Completed
I Inactive
P Pending
R Running
Ejemplo de un query para ver los Concurrentes Pendientes por cola
SELECT concurrent_queue_name "QUEUE",
user_CONCURRENT_PROGRAM_NAME "PROGRAM",
COUNT (1) CANT
FROM fnd_concurrent_worker_requests
WHERE phase_code = 'P'
AND hold_flag != 'Y'
AND requested_start_date <= SYSDATE
GROUP BY user_CONCURRENT_PROGRAM_NAME, concurrent_queue_name;
