DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, January 16, 2017

Query to check the pending concurrent requests and the count,status etc.




set lines 300;
set pages 300;
col "  CONCURRENT_PROGRAM_NAME" for a60;
col QUEUE_NAME for a12;
col status_code for a12;
select USER_CONCURRENT_PROGRAM_NAME "  CONCURRENT_PROGRAM_NAME",concurrent_queue_name "QUEUE_NAME",
 priority,decode(phase_code,'P','Pending') "PHASE",
decode(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') "STATUS",
status_code,count(*) from
apps.fnd_concurrent_worker_requests
where  phase_code='P' and hold_flag!='Y'
and requested_start_date<=sysdate
and concurrent_queue_name<> 'FNDCRM'
and concurrent_queue_name<> 'GEMSPS'
group by
user_CONCURRENT_PROGRAM_NAME,
concurrent_queue_name,priority,phase_code,status_code
order by count(*) desc;

No comments: