Friday, August 22, 2014

SQL to Derive Concurrent Managers with running process details

SQL to Derive Concurrent Managers list with process details in Oracle Applications


By using below sql, you will be able to derive concurrent managers running in the system.

Also you will be able to collect how many processes are running under each concurrent manager and in which application.

SELECT fat.application_name,
 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')  "Concurrent Manager",
 Max_Processes  ,                                                                                                                                                                                                                                                                                                                                                                                                                                        
 Running_Processes ,
 fcq.last_update_date,
 fcq.creation_date
From Apps.Fnd_Concurrent_Queues Fcq, Apps.Fnd_Application_Tl Fat
Where Fcq.Application_Id=Fat.Application_Id
and 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');
 

2 comments:

  1. Oracle Forms Management Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/oracle-forms-management-online-training-126.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Oracle Forms Management Online Training, Oracle Forms Management Training, Oracle Forms Management, Oracle Forms Management Online Training| Oracle Forms Management Training| Oracle Forms Management| "Courses at 21st Century Software Solutions
    Talend Online Training -Hyperion Online Training - IBM Unica Online Training - Siteminder Online Training - SharePoint Online Training - Informatica Online Training - SalesForce Online Training - Many more… | Call Us +917386622889 - +919000444287 - contact@21cssindia.com
    Visit: http://www.21cssindia.com/courses.html"

    ReplyDelete
  2. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete