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 JANUARY 15, 2023
Applies to:Oracle Concurrent Processing - Version 12.1.3 and later
Information in this document applies to any platform.
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 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.
The DB was refreshed.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document