Oracle Workflow Services in Oracle Applications are encountering problems.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. Even I tried from Concurrent>Manager>Administer form but still these were not starting.
Workflow components was not coming Up and showing as below
Target - 1 Actual - 0
Workflow service Components and there shotnames.
Workflow Agent Listener Service - WFALSNRSVC
Workflow Mailer Service - WFMLRSVC
Workflow Document Web Services Service - WFWSSVC
We can find the same using below query as well.
Workflow Agent Listener Service:
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:
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:
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
Now to fix the issue we will follow below steps
1) Make the the processes value zero for these services.
UPDATE fnd_concurrent_queues
SET running_processes = 0, max_processes = 0
where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC');
3 rows updated.
2) Update Control codes with NULL
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.
3) Make Target node as Null option
UPDATE fnd_concurrent_queues
SET target_node = null
where concurrent_queue_name in ('WFWSSVC','WFALSNRSVC','WFMLRSVC');
3 rows updated.
4) Commit
SQL>commit;
Commit complete.
5) Check Workflow Concurrent Managers
Wait for few minutes, the Internal concurrent manager will bring up services automatically.
We can check the components status using following SQL statements.
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> select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='WFALSNRSVC';
C RUNNING_PROCESSES MAX_PROCESSES
- ----------------- -------------
1 1
SQL> select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='WFWSSVC';
C RUNNING_PROCESSES MAX_PROCESSES
- ----------------- -------------
1 1
Post a Comment
Post a Comment