internal manager and all manager shows actual=1 and target=1 AND OTHER ARE ACTUAL=0 TARGET=0

REF:MOS  ID 555081.1

Issue: when internal manager and all manager shows actual=1 and target=1 AND OTHER ARE ACTUAL=0 TARGET=0

 SOLUTION FOR THIS ISSUE:

Step1:stop application services  ./adstpall.sh apps/apps

step2: sqlplus apps/apps

update apps.fnd_concurrent_queues set node_name = 'OPTIMEBS26' where node_name is NULL;

           update fnd_concurrent_queues set TARGET_NODE='OPTIMEBS26' where TARGET_NODE is NULL;

step3:  EXEC FND_CONC_CLONE.SETUP_CLEAN;

             COMMIT;

            EXIT;

          commit;

step4: Ran cmclean.sql by loging database with apps/apps user.

Step5: LAST STEP: RUN AUTO CONFIG ON APPLICATION TIER

If still not resolving then try below:

Stop application services again and run below command as DB user as “apps”.

UPDATE fnd_concurrent_queues set target_node = 'OPTIMEBS64';

UPDATE fnd_concurrent_queues set node_name = 'OPTIMEBS64';

Check all target and node with below commands :

select control_code,target_node,node_name,CONCURRENT_QUEUE_NAME from fnd_concurrent_queues;

EXEC FND_CONC_CLONE.SETUP_CLEAN;

             COMMIT;

            EXIT;

          commit;

and start application services .