fnd_concurrent_queues table control_code column meaning

Concurrent Manger queues Status code meaning

SQL> select lookup_code,meaning from apps.fnd_lookups where lookup_type = 'CP_CONTROL_CODE' order by lookup_code;

LOOKUP_CODE                    MEANING
------------------------------ -------------------------------------------------
A                              Activating
B                              Activated
D                              Deactivating
E                              Deactivated
N                              Target node/queue unavailable
O                              Suspending concurrent manager
P                              Suspended
Q                              Resuming concurrent manager
R                              Restarting
T                              Terminating
U                              Updating environment information

LOOKUP_CODE                    MEANING
------------------------------ -------------------------------------------------
V                              Verifying
X                              Terminated

13 rows selected.

Concurrent Manager Error: Check that your system has enough resources to start a concurrent manager process after Clone/Refresh

Concurrent Manager Error: Check that your system has enough resources to start a concurrent manager process after Clone/Refresh

Routine AFPEIM encountered an error while starting concurrent manager STANDARD with library /u01/app/apptst/apps/apps_st/appl/fnd/12.0.0/bin/FNDLIBR.

Check that your system has enough resources to start a concurrent manager process. Contact your system a : 21-SEP-2013 14:04:21
Starting STANDARD Concurrent Manager               : 21-SEP-2013 14:04:21

CONC-SM TNS FAIL
Routine AFPEIM encountered an error while starting concurrent manager STANDARD with library /u01/app/apptst/apps/apps_st/appl/fnd/12.0.0/bin/FNDLIBR.

Check that your system has enough resources to start a concurrent manager process. Contact your system a : 21-SEP-2013 14:04:21
                     Process monitor session ended : 21-SEP-2013 14:04:21

Solution:

1. Clean fnd_concurrent_queues

Clean fnd_concurrent_queues

Connect as APPS user Get the details using below query

SQL> select unique(node_name) from fnd_concurrent_queues;

NODE_NAME
------------------------------
PRODAPP1
PRODAPP2
DEVAPP1

Replace the Source Node Values with Target Values

SQL> update fnd_concurrent_queues set node_name='DEVAPP1' where node_name='PRODAPP1';

1 row updated.

SQL> update fnd_concurrent_queues set node_name='DEVAPP2' where node_name='PRODAPP2';

2 rows updated.

SQL> commit;

Restart the Concurrent Manager