Start/Stop the Workflow Services in Oracle Apps

来源：互联网发布：2016年网络新书排行榜编辑：程序博客网时间：2024/05/19 20:01

Navigation:Navigate to Workflow Administrator> Oracle Application Manager > Workflow Manager > Service Components > Workflow Agent Listener Services

Start and Stop the Oracle Workflow Services

--------------------------------------------------------------------------------------------

There also is a script to check all workflow service status

SET PAGESIZE 400SET LINESIZE 120SET PAGESIZE 50COLUMN COMPONENT_NAME FORMAT A45COLUMN STARTUP_MODE FORMAT A15COLUMN COMPONENT_STATUS FORMAT A15SELECT FSC.COMPONENT_NAME,FSC.STARTUP_MODE,FSC.COMPONENT_STATUSFROM APPS.FND_CONCURRENT_QUEUES_VL FCQ, FND_SVC_COMPONENTS FSCWHERE FSC.CONCURRENT_QUEUE_ID = FCQ.CONCURRENT_QUEUE_ID(+)ORDER BY COMPONENT_STATUS , STARTUP_MODE , COMPONENT_NAME;

Sample Output :

COMPONENT_NAMESTARTUP_MODECOMPONENT_STATUSWorkflow Notification MailerAUTOMATICDEACTIVATED_SYSTEMECX Inbound Agent ListenerAUTOMATICRUNNINGECX Transaction Agent ListenerAUTOMATICRUNNINGWF_JMS_IN Listener(M4U)AUTOMATICRUNNINGWeb Services IN AgentAUTOMATICRUNNINGWeb Services OUT AgentAUTOMATICRUNNINGWorkflow Deferred Agent ListenerAUTOMATICRUNNINGWorkflow Deferred Notification Agent ListenerAUTOMATICRUNNINGWorkflow Error Agent ListenerAUTOMATICRUNNINGWorkflow Inbound JMS Agent ListenerAUTOMATICRUNNINGWorkflow Inbound Notifications Agent ListenerAUTOMATICRUNNINGWorkflow Java Deferred Agent ListenerAUTOMATICRUNNINGWorkflow Java Error Agent ListenerAUTOMATICRUNNING