Check Workflow components(Notification mailers, listeners etc) which are not running in Oracle Apps

Use the below query to Check Workflow components(Notification mailers, listeners etc) which are not running From back-end:-


  SELECT component_type,
         component_name,
         Component_status,
         COMPONENT_STATUS_INFO Error
    FROM fnd_svc_components
   WHERE component_type LIKE 'WF%' AND component_status <> 'RUNNING'
ORDER BY 1 DESC, 2, 3;