R12 E-Business Suite Concurrent Managers Fail To Start Via Script adcmctl.sh After A DB Refresh Due To Errors 'FDPRRC failed due to ORA-00904: "NLS_SORT": invalid identifier' And ' insert_fcp failed due to ORA-00054: resource busy and acquire with NOWAIT' (Doc ID 2284216.1)

Last updated on APRIL 17, 2024

Applies to:

Symptoms

E-Business Suite R12 Concurrent Processing, Concurrent Manager related issues

 Starting the concurrent managers with script adcmctl.sh fails with the following error:

 You are running adcmctl.sh version 120.17.12010000.5

adcmctl.sh: Shutting down concurrent managers for EBS_BALANCE ...
ORACLE Password:
ORACLE error 904 in FDPRRC

Cause: FDPRRC failed due to ORA-00904: "NLS_SORT": invalid identifier

The Internal Concurrent Manager (ICM) log is showing the following errors:

ORACLE error 54 in insert_fcp

Cause: insert_fcp failed due to ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at "APPS.FND_CP_FNDSM", line 134
ORA-06512: at line 1.

The SQL statement being executed at the time of the error was: begin fnd_cp_fndsm.register_fndsm_fcp(:c,:n,:o,:l,:m,:t); end; and was executed from the file &ERRFILE.
Could not initialize the Service Manager FNDSM_<SM_NAME>. Verify that S1 has been registered for concurrent processing.
An error ocurred in client-side routine afpsmcsm for Service Manager FNDSM_<SM_NAME>. The routine returned code 126.

Changes

 The DB was refreshed.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.