ORA-06512: at “APPS.FND_CP_FNDSM”, line 29 Concurrent Manger not starting

When i checked concurrent manager log under $APPLCSF/log/<SID>.mgr

I see below error:

Cause: cleanup_node failed due to ORA-01427: single-row subquery returns more than one row

ORA-06512: at “APPS.FND_CP_FNDSM”, line 29
ORA-06512: at line 1.

The SQL statement being executed at the time of Routine AFPEIM encountered an error while starting concurrent manager STANDARD with library /dev/applmgr/R12/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 syst : 08-OCT-2013 00:30:51

Starting IEU_WL_CS Concurrent Manager : 08-OCT-2013 00:30:51

Could not initialize the Service Manager FNDSM_apps01_dev. Verify that apps01 has been registered for concurrent processing.
ORACLE error 1427 in cleanup_node

Cause: cleanup_node failed due to ORA-01427: single-row subquery returns more than one row
ORA-06512: at “APPS.FND_CP_FNDSM”, line 29
ORA-06512: at line 1.

The SQL statement being executed at the time of
Routine AFPEIM encountered an error while starting concurrent manager IEU_WL_CS with library /dev/applmgr/R12/apps/apps_st/appl/fnd/12.0.0/bin/FNDLIBR.

Solution

———-

sqlplus apps/apps

sql>exec fnd_conc_clone.setup_clean;

commit;

sql>@cmclean.sql

Started the concurrent manager on the application tier and it worked