QUERY TO FIND THE WORKFLOW SERVICE COMPONENETS STATUS

This following query is used to fetch the status of the workflow service components.

login as APPS user,

SQL> desc apps.fnd_svc_components;
Name Null? Type
—————————————– ——– —————————-
COMPONENT_ID NOT NULL NUMBER
COMPONENT_NAME NOT NULL VARCHAR2(80)
COMPONENT_STATUS NOT NULL VARCHAR2(30)
COMPONENT_TYPE NOT NULL VARCHAR2(30)
STARTUP_MODE NOT NULL VARCHAR2(30)
CONTAINER_TYPE NOT NULL VARCHAR2(30)
CUSTOMIZATION_LEVEL NOT NULL VARCHAR2(30)
APPLICATION_ID NUMBER
CONCURRENT_QUEUE_ID NUMBER
STANDALONE_CONTAINER_NAME VARCHAR2(30)
INBOUND_AGENT_NAME VARCHAR2(30)
OUTBOUND_AGENT_NAME VARCHAR2(30)
CORRELATION_ID VARCHAR2(240)
MAX_IDLE_TIME NUMBER
COMPONENT_STATUS_INFO VARCHAR2(1996)
CREATION_DATE NOT NULL DATE
CREATED_BY NOT NULL NUMBER(15)
LAST_UPDATE_DATE NOT NULL DATE
LAST_UPDATED_BY NOT NULL NUMBER(15)
LAST_UPDATE_LOGIN NUMBER(15)
OBJECT_VERSION_NUMBER NOT NULL NUMBER

select COMPONENT_NAME,COMPONENT_STATUS from apps.fnd_svc_components where COMPONENT_STATUS in (‘RUNNING’);