CM was not coming up , even while taking down was returning error :

shutdown error:
ORACLE Password:
ORACLE error 904 in FDPRRC

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

The SQL statement being executed at the time of the error was:  and was executed from the file .
Cannot submit your concurrent request

Once killed the process, on start also only ICM was coming up and rest manager remains down.
ICM log file was having below error :
use: 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 following actions were performed in order to solve the issue but without success:

- cleaned the fnd_nodes
- ran autoconfig in db tier and apps tier
- executed $FND_TOP/patch/115/sql/afdcm037.sql
- ran autoconfig again

TO check fnd_node details:
set lines 180
set pages 50
col NODE_NAME for a15 WORD_WRAPPED
COL SUPPORT_DB for a12
COL SUPPORT_CP for a12
COL SUPPORT_ADMIN for a15
COL SUPPORT_FORMS for a15
COL SUPPORT_WEB for a12
COL HOST for a15 WORD_WRAPPED
Col STATUS for a10
col DOMAIN for a20 WORD_WRAPPED
select NODE_NAME,SUPPORT_DB,SUPPORT_CP,SUPPORT_ADMIN,SUPPORT_WEB,SUPPORT_FORMS,STATUS,HOST,DOMAIN
from apps.fnd_nodes;

select control_code from fnd_concurrent_queues where concurrent_queue_name = 'FNDSCH'

Main cause:

Checking the AFCPFSMB.pls file version on the files system and on the DB side, there is a mismatch:
- on the file system:
adident Header $FND_TOP/patch/115/sql/AFCPFSMB.pls

AFCPFSMB.pls 120.7.12010000.6

- while on Database:
select text from dba_source where name = 'FND_CP_FNDSM' and text like '%Header%';

AFCPFSMB.pls 120.7.12010000.2

Solution:

Reloading this file without doing anything else is not recommended.

Re-apply patch 15981176 by following the read-me and make sure it updates the file correctly.

Then re-test to see if all the concurrent managers start successfully.

Reference doc id for the same:
Concurrent Managers Fail to Start: "insert_fcp failed due to ORA-00054" (Doc ID 2213565.1)