ORA-06512: at "APPS.FND_CP_FNDSM"

 After clone Concurrent manager shut down after 3/4 hours.

Internal concurrent manager log found below error

logfile=/apps/UAT/inst/apps/UAT_ora/logs/appl/conc/log/UAT_101.mgr

Cause: insert_fcp failed due to ORA-01403: no data found

ORA-06512: at "APPS.FND_CP_FNDSM", line 149

ORA-06512: at line 1.

Solution :-

stop Concurrent Managers using adcmctl.sh

[applmgr@oracle scripts]$ ./adcmctl.sh stop apps/***

[applmgr@oracle ~]$ ps -ef|grep FNDLIBR 

[applmgr@oracle scripts]$ sqlplus apps/*****

SQL> select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like 'FNDSM%';

 CONCURRENT_QUEUE_NAME

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

FNDSM_ORACLE

 

SQL> set lines 200

SQL> column CONTROL_CODE format A15

 SQL> select CONCURRENT_QUEUE_NAME, CONTROL_CODE , TARGET_NODE, NODE_NAME   from FND_CONCURRENT_QUEUES where concurrent_queue_name like 'OAMGCS_%';

 

CONCURRENT_QUEUE_NAME          CONTROL_CODE    TARGET_NODE   NODE_NAME

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

OAMGCS_ORACLE                                                E                            NULL                   ORACLE

 

 The standard codes used by Oracle Applications are as followings:

'A', -> 'Activate concurrent manager'
'D', -> 'Deactivate concurrent manager'
'E', -> 'Deactivated'
'N', -> 'Target node/queue unavailable'
'R', -> 'Restart concurrent manager'
'T', -> 'Terminate requests and deactivate manager'
'U', -> 'Update concurrent manager env inf.'
'V', -> 'Verify concurrent managers status'
'X', -> 'Terminated'

STATUS_CODE Column:

A Waiting

B Resuming

C Normal

D Cancelled

E Error

F Scheduled

G Warning

H On Hold

I Normal

M No Manager

Q Standby

R Normal

S Suspended

T Terminating

U Disabled

W Paused

X Terminated

Z Waiting

PHASE_CODE column

C Completed

I Inactive

P Pending

R Running

SQL> update FND_CONCURRENT_QUEUES set control_code = null where concurrent_queue_name = 'OAMGCS_ORACLE';

 1 row updated.

 SQL> commit;

 Commit complete.

 SQL> update FND_CONCURRENT_QUEUES set TARGET_NODE='ORACLE' where CONCURRENT_QUEUE_NAME='OAMGCS_ORACLE';

 1 row updated.

 SQL> commit;

 Commit complete.

 SQL> set lines 200

SQL> column CONTROL_CODE format A15

 SQL> select CONCURRENT_QUEUE_NAME, CONTROL_CODE , TARGET_NODE, NODE_NAME   from FND_CONCURRENT_QUEUES where concurrent_queue_name like 'OAMGCS_%';

 CONCURRENT_QUEUE_NAME----CONTROL_CODE----TARGET_NODE----NODE_NAME

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

OAMGCS_ORACLE---null-- ORACLE-------- ORACLE

 

start Concurrent Managers using adcmctl.sh

[applmgr@oracle scripts]$ ./adcmctl.sh start apps/***

[applmgr@oracle ~]$ ps -ef|grep FNDLIBR