Concurrent Manager Status using SQL

Concurrent Manager Status using SQL

The below query is used to get all the concurrent manager status from back end. 

Most of the times we need to quickly check the status of the CM.  

select decode(CONCURRENT_QUEUE_NAME,
 'FNDICM','Internal Manager',
 'FNDCRM','Conflict Resolution Manager',
 'AMSDMIN','Marketing Data Mining Manager',
 'C_AQCT_SVC','C AQCART Service',
 'FFTM','FastFormula Transaction Manager',
 'FNDCPOPP','Output Post Processor',
 'FNDSCH','Scheduler/Prereleaser Manager',
 'FNDSM_AQHERP','Service Manager: AQHERP',
 'FTE_TXN_MANAGER','Transportation Manager',
 'IEU_SH_CS','Session History Cleanup',
 'IEU_WL_CS',
 'UWQ Worklist Items Release for Crashed session',
 'INVMGR','Inventory Manager','
 INVTMRPM','INV Remote Procedure Manager','OAMCOLMGR',
 'OAM Metrics Collection Manager',
 'PASMGR','PA Streamline Manager',
 'PODAMGR','PO Document Approval Manager',
 'RCVOLTM','Receiving Transaction Manager',
 'STANDARD','Standard Manager',
 'WFALSNRSVC','Workflow Agent Listener Service',
 'WFMLRSVC','Workflow Mailer Service','WFWSSVC',
 'Workflow Document Web Services Service',
 'WMSTAMGR','WMS Task Archiving Manager',
 'XDP_APPL_SVC','SFM Application Monitoring Service',
 'XDP_CTRL_SVC',
 'SFM Controller Service',
 'XDP_Q_EVENT_SVC','SFM Event Manager Queue Service',
 'XDP_Q_FA_SVC','SFM Fulfillment Actions Queue Service',
 'XDP_Q_FE_READY_SVC','SFM Fulfillment Element Ready Queue Service',
 'XDP_Q_IN_MSG_SVC','SFM Inbound Messages Queue Service',
 'XDP_Q_ORDER_SVC',
 'SFM Order Queue Service',
 'XDP_Q_TIMER_SVC','SFM Timer Queue Service',
 'XDP_Q_WI_SVC','SFM Work Item Queue Service',
 'XDP_SMIT_SVC','SFM SM Interface Test Service') as "Concurrent Manager's Name",
  max_processes as "TARGET Processes",
  running_processes as "ACTUAL Processes" 
  from apps.fnd_concurrent_queues 
 where CONCURRENT_QUEUE_NAME 
 in ('FNDICM','FNDCRM','AMSDMIN',

'C_AQCT_SVC','FFTM','FNDCPOPP','FNDSCH',

'FNDSM_AQHERP','FTE_TXN_MANAGER','IEU_SH_CS',

'IEU_WL_CS','INVMGR','INVTMRPM',
 'OAMCOLMGR','PASMGR','PODAMGR','RCVOLTM','STANDARD',

'WFALSNRSVC','WFMLRSVC','WFWSSVC','WMSTAMGR',

'XDP_APPL_SVC','XDP_CTRL_SVC','XDP_Q_EVENT_SVC',
 'XDP_Q_FA_SVC','XDP_Q_FE_READY_SVC',

'XDP_Q_IN_MSG_SVC','XDP_Q_ORDER_SVC',

'XDP_Q_TIMER_SVC','XDP_Q_WI_SVC',

'XDP_SMIT_SVC')
 order by max_processes
 /

Output

------

Concurrent Manager's Name                     |TARGET Processes|ACTUAL Processes
----------------------------------------------|----------------|----------------
Workflow Mailer Service                       |               0|               0
SFM SM Interface Test Service                 |               0|               0
SFM Application Monitoring Service            |               0|               0
SFM Timer Queue Service                       |               0|               0
SFM Inbound Messages Queue Service            |               0|               0
SFM Event Manager Queue Service               |               0|               0
SFM Fulfillment Element Ready Queue Service   |               0|               0
SFM Fulfillment Actions Queue Service         |               0|               0
SFM Work Item Queue Service                   |               0|               0
SFM Order Queue Service                       |               0|               0
SFM Controller Service                        |               0|               0
C AQCART Service                              |               0|               0
Transportation Manager                        |               0|               0
Workflow Document Web Services Service        |               0|               0
WMS Task Archiving Manager                    |               0|               0
FastFormula Transaction Manager               |               0|               0
Internal Manager                              |               0|               1
Workflow Agent Listener Service               |               0|               0
Inventory Manager                             |               1|               0
PA Streamline Manager                         |               1|               1
Receiving Transaction Manager                 |               1|               0
PO Document Approval Manager                  |               1|               0
Session History Cleanup                       |               1|               0
Scheduler/Prereleaser Manager                 |               1|               0
Output Post Processor                         |               1|               1
Conflict Resolution Manager                   |               1|               0
OAM Metrics Collection Manager                |               1|               0
UWQ Worklist Items Release for Crashed session|               1|               0
                                              |               1|               0
Marketing Data Mining Manager                 |               1|               0
Standard Manager                              |              15|               0

31 rows selected.