Remote IT Support!! Please contact us

For Any Remote Support,Implementation/Upgrade Projects,Queries,Collaborations please mail us at

FND_DCP.REQUEST_SESSION_LOCK error on starting Concurrent Managers

No comments
We might observe the below issue when starting the ICM.

Routine &ROUTINE has attempted to start the internal concurrent manager.  The ICM is already running.  Contact you system administrator for further assistance.afpdlrq received an unsuccessful result from PL/SQL procedure or function FND_DCP.Request_Session_Lock.
Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request.
Possible DBMS_LOCK.Request resultCall to establish_icm failed
The Internal Concurrent Manager has encountered an error.


If we check status it will show Active but no FNDLIBR process seen on the server.


This must be due to a blocking session in the database.

We need to clear the Database session.

1. Run sql to check for blocking session :

SQL> SELECT v$access.sid, v$session.serial#
FROM v$session,v$access
WHERE v$access.sid = v$session.sid and v$access.object = 'FND_CP_FNDSM'
GROUP BY v$access.sid, v$session.serial#;  

       SID    SERIAL#
---------- ----------
       523         17


2. Kill blocking session :

SQL> alter system kill session '523,17';

System altered.

Start the Concurrent Managers and Re-try.

No comments :

Post a Comment

ADOP fails with [ERROR] ETCC not run in the database node DBHOSTNAME in R12.2

No comments
We might some time get into below issue after clone or after installing AD and TXK patches.


ETCC not run in the database node [Node Name]
                The EBS Technology Codelevel Checker needs to be run on the database node.
                It is available as Patch 17537119.


It might be due to mismatch in host name between APPS.FND_NODES and APPLSYS.TXK_TCC_RESULTS tables.


1. Login to the database as APPS schema.
2. Validate the data in FND_NODES  and TXK_TCC_RESULTS  table.
3. Download the ETCC Patch - 17537119 ,unzip the patch and  run the following on the Database Node (Recommended)



3. Update the correct node name in APPLSYS.TXK_TCC_RESULTS table.

No comments :

Post a Comment