Workflow Services Are Not Running

Concurrent Manager, Workflow Activities

There is an issue with Oracle Workflow Services in Oracle Applications.The workflow components are not starting when I was trying to start up the services from front end web-form using system administrator responsibility.These services appear with a Target value of 1 and an Actual value of 0.

I have tried two times to  activate and deactivate workflow managers  but it is not worked. After that I searched over internet and got one solution from one of the oracle blogs spicyoracle and applied the solution.

Solution:

Step1: Try to find out short names for Workflow services are as bellow. 

·         Workflow Agent Listener Service

·         Workflow Mailer Service

·         Workflow Document Web Services Service

Workflow Agent Listener Service:

1 2 3 4 5

SQL> select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Agent Listener Service'; CONCURRENT_QUEUE_NAME ------------------------------ WFALSNRSVC

Workflow Mailer Service:

1 2 3 4 5

SQL> select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Mailer Service'; CONCURRENT_QUEUE_NAME ------------------------------ WFMLRSVC

Workflow Document Web Services Service:

1 2 3 4 5

SQL> select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Document Web Services Service'; CONCURRENT_QUEUE_NAME ------------------------------ WFWSSVC

Step2: Update process values as zero is as bellow.

1 2 3 4 5

UPDATE  fnd_concurrent_queues SET running_processes = 0, max_processes = 0 where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC'); 3 rows updated.

Step3: Update Control codes with NULL

1 2 3 4 5 6 7

UPDATE  fnd_concurrent_queues SET control_code = NULL WHERE concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC') AND control_code not in ('E', 'R', 'X') AND control_code IS NOT NULL; 0 rows updated.

Step4: Make Target node as Null option and commit it

1 2 3 4 5 6 7 8 9 10 11

UPDATE  fnd_concurrent_queues SET target_node = null where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC'); 3 rows updated. SQL>commit; Commit complete. SQL>

Step5: Check Workflow Concurrent Mangers

The Internal concurrent manger will bring up the services once you done above operation.We can check by using following sql statements.

Check Status of Workflow Agent Listener Service:

1 2 3 4 5 6 7

SQL> select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='WFALSNRSVC'; C RUNNING_PROCESSES MAX_PROCESSES - ----------------- -------------                   1             1 SQL>

Check Status of Workflow Mailer Service:

1 2 3 4 5

SQL> select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='WFALSNRSVC'; C RUNNING_PROCESSES MAX_PROCESSES - ----------------- -------------                   1             1

Check Status of Workflow Document Web Services Service:

1 2 3 4 5

SQL> select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='WFWSSVC'; C RUNNING_PROCESSES MAX_PROCESSES - ----------------- -------------                   1             1

It is good practice for restarting the workflow services without shutdown All Concurrent managers’ services and run cmclean.sql script.       The ICM will take care of to starting the service once you followed above method.

 To Check whether the Workflow Components are Up & Running?
------------------------------------------------------------------------------------

SQL> col component_name format a45;

col component_status format a30;

set linesize 500 pagesize 200;

select component_name,component_status from fnd_svc_components;

COMPONENT_NAME                                COMPONENT_STATUS

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

ECX Inbound Agent Listener                    RUNNING

ECX Transaction Agent Listener                RUNNING

Workflow Deferred Agent Listener              RUNNING

Workflow Deferred Notification Agent Listener RUNNING

Workflow Error Agent Listener                 RUNNING

Workflow Inbound Notifications Agent Listener RUNNING

Workflow Notification Mailer                  STOPPED

Web Services OUT Agent                        RUNNING

Web Services IN Agent                         RUNNING

Workflow Java Deferred Agent Listener         RUNNING

Workflow Java Error Agent Listener            RUNNING

Workflow Inbound JMS Agent Listener           STOPPED

WF Deferred Agnt Listener1                    RUNNING

WF Deferred Agnt Listener2                    RUNNING

WF Deferred Agnt Listener3                    RUNNING

WF Deferred Agnt Listener4                    RUNNING

16 rows selected.

WF Component ID
------------------------

select component_id
from fnd_svc_components
where component_name = 'Workflow Notification Mailer';


COMPONENT_ID
------------
       10006