Concurrent Manager error:FND_DCP.REQUEST_SESSION_LOCK/DBMS_LOCK.Request resultCall to establish_icm failed/function FND_DCP   Leave a comment

You see the error in ICM LOG: Please see screeshot.

conc1

 

Solution:

• Ensure Concurrent Managers are down.

Ensure no FNDLIBR process running

ps –ef|grep FNDLIBR (kill if any FNDLIBR or FNDSM is running)

• Run cmclea.sql ( commit is mandatory)

• Then Start the services – adstrtal.sh   apps/apps

• Now you can see Managers Up and running.

Some times even this wont resolve the issue. Then perform the below action plan

1. Stop all services and concurrent managers
2. Stop and restart the database

run CMCLEAN.sql again
3. Restart the services and concurrent managers
4. Verify if the issue remains

This is caused due to unclean shutdown and startup of concurrent manager service. Sometimes you will see database locks due to this issue, in this case its better to bounce the DB and run cmclean and start the services.

This will definitely resolve the issue.

Advertisements

Posted October 16, 2013 by balaoracledba.com in 11i/R12, Issues, OracleAppsR12

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: