Checking the status of Workflow Mailer and other Workflow Components

Today I am going to post some handy scripts which you can use to run a quick status check on Oracle Apps Workflow mailer and other workflow components:

1. Workflow Mailer: Run the following scripts as apps:

set linesize 100
col Component format a40
SELECT component_name as Component, component_status as Status FROM fnd_svc_components WHERE component_type = 'WF_MAILER';


SQL> set linesize 100
col Component format a40
SELECT component_name as Component, component_status as Status FROM fnd_svc_components WHERE component_type = 'WF_MAILER';SQL> SQL>

COMPONENT                                STATUS
---------------------------------------- ------------------------------
Workflow Notification Mailer             RUNNING

SQL>


set linesize 150
set pagesize 9999
col COMPONENT_NAME format a50
col COMPONENT_STATUS format a50
select SC.COMPONENT_TYPE, SC.COMPONENT_NAME, FND_SVC_COMPONENT.Get_Component_Status(SC.COMPONENT_NAME) COMPONENT_STATUS from FND_SVC_COMPONENTS SC order by 1, 2;



SQL> set linesize 150
SQL>  set pagesize 9999
SQL>  col COMPONENT_NAME format a50
SQL>  col COMPONENT_STATUS format a50
 select SC.COMPONENT_TYPE, SC.COMPONENT_NAME, FND_SVC_COMPONENT.Get_Component_Status(SC.COMPONENT_NAME) COMPONENT_STATUS from FND_SVC_COMPONENTS SC order by 1, 2;SQL>

COMPONENT_TYPE                 COMPONENT_NAME                                     COMPONENT_STATUS
------------------------------ -------------------------------------------------- --------------------------------------------------
WF_AGENT_LISTENER              ECX Inbound Agent Listener                         STOPPED
WF_AGENT_LISTENER              ECX Transaction Agent Listener                     STOPPED
WF_AGENT_LISTENER              Workflow Deferred Agent Listener                   RUNNING
WF_AGENT_LISTENER              Workflow Deferred Notification Agent Listener      DEACTIVATED_USER
WF_AGENT_LISTENER              Workflow Error Agent Listener                      RUNNING
WF_AGENT_LISTENER              Workflow Inbound JMS Agent Listener                STOPPED
WF_AGENT_LISTENER              Workflow Inbound Notifications Agent Listener      RUNNING
WF_DOCUMENT_WEB_SERVICES       Web Services OUT Agent                             STOPPED
WF_JAVA_AGENT_LISTENER         WF_JMS_IN Listener(M4U)                            RUNNING
WF_JAVA_AGENT_LISTENER         Web Services IN Agent                              STOPPED
WF_JAVA_AGENT_LISTENER         Workflow Java Deferred Agent Listener              RUNNING
WF_JAVA_AGENT_LISTENER         Workflow Java Error Agent Listener                 RUNNING
WF_MAILER                      Workflow Notification Mailer                       RUNNING

13 rows selected.

SQL>