Workflow Services Are Not Running by showing mismatch in Actual and Target

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 from concurrent managers screen and from Workflow Agent Listener , using system administrator responsibility.These services appear with a Target value of 1 and an Actual value of 0 and services were not coming up . 

Workflow Agent Listener Service:

====================================

select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Agent Listener Service'; 

Workflow Mailer Service:

======================== 

select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Workflow Mailer Service';

Workflow Document Web Services Service:

===========================================

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

Update process values as zero is as bellow.

====================================================

UPDATE  apps.fnd_concurrent_queues

SET running_processes = 0, max_processes = 0

where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC');

Update Control codes with NULL

=====================================

UPDATE  apps.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;

Make Target node as Null option and commit it

====================================================

UPDATE  apps.fnd_concurrent_queues

SET target_node = null

where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC');

EXAMPLE

=========

SQL> UPDATE  apps.fnd_concurrent_queues

SET running_processes = 0, max_processes = 0

where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC');  2    3

3 rows updated.

SQL> UPDATE  apps.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;  2    3    4    5

0 rows updated.

SQL> UPDATE  apps.fnd_concurrent_queues

SET target_node = null

where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC');  2    3

3 rows updated.

SQL> commit;

Commit complete.

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 whether the Service Manager is up and Running by the following Query :

=====================================================================================

set lines 200 pages 900

col CONCURRENT_QUEUE_NAME for a50

select CONCURRENT_QUEUE_NAME, ENABLED_FLAG, MAX_PROCESSES, RUNNING_PROCESSES

from apps.FND_CONCURRENT_QUEUES

where CONCURRENT_QUEUE_NAME like 'FNDSM%';