Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

Query to find workflow services are up and running?

Query to find workflow services are up and running?

Query to find workflow services are up and running?

SELECT   fcq.user_concurrent_queue_name container_name,
         DECODE (fcp.os_process_id,
                 NULL, ‘Not
Running’,
                 fcp.os_process_id
                ) procid,
         fcq.max_processes target, fcq.running_processes actual,
         fcq.enabled_flag enabled, fsc.component_name, fsc.component_type,
         fsc.startup_mode, fsc.component_status, SYSDATE dates
    FROM apps.fnd_concurrent_queues_vl fcq,
         apps.fnd_cp_services fcs,
         apps.fnd_concurrent_processes fcp,
         fnd_svc_components fsc
   WHERE fcq.manager_type = fcs.service_id
     AND fcs.service_handle = ‘FNDCPGSC’
     AND fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
     AND fcq.concurrent_queue_id = fcp.concurrent_queue_id(+)
     AND fcq.application_id = fcp.queue_application_id(+)
     AND fcp.process_status_code(+) = ‘A’
ORDER BY fcp.os_process_id, fsc.startup_mode;

 

 

Related Posts
Write a comment