Home / APPS DBA / 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;

 

 

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleEBSerror

AC-50480: Internal error occurred

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora

Leave a Reply