My Oracle Support Banner

R12 E-Business Suite Concurrent Managers Fail To Start Via Script 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 fails with the following error:

 You are running version 120.17.12010000.5 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.


 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

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