Concurrent Managers Are Down 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"

Concurrent Managers Are Down 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" [ID 1308821.1]
  Modified 19-JUN-2011     Type PROBLEM     Status ARCHIVED
In this Document
  Symptoms
  Cause
  Solution
  References

Applies to:

Oracle Application Object Library - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.
Symptoms

On : 11.5.10.2 version, Application report sets, repport server, seeded reports

While trying to start concurrent managers getting the below error (PCP implemented):

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 o
Routine AFPEIM encountered an error while starting concurrent manager STANDARD with library /mnt/oraarch1/arch1appl/fnd/11.5.0/bin/FNDLIBR.

Check that your system has enough resources to start a concurrent manager process. Contact your system administrat : 28-MAR-2011 05:36:25
Starting STANDARD Concurrent Manager : 28-MAR-2011 05:36:25
ORACLE error 1422 in get_sm_info
Cause

Need to clean tables and repopulate them with AutoConfig.
Solution

1 - Stop the concurrent managers , Forms server and Apache

2 - Run the following SQL statement :

EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;

3 - Run AutoConfig.