Oracle EBS Concurrent Manager Troubleshooting

In Oracle EBS version 12.2.6, Internal concurrent manager had an unexpected Outage.
ICM logfile has the error message  ORA-04068: existing state of packages has been discarded
====================


Shutting down Internal Concurrent Manager : 30-JAN-2018 12:09:54


List of errors encountered:
…………………………………………………………………..


_ 1 _
Error in DBMS lock request by handle. (ROUTINE=AFPGMG) (REASON=ORACLE
error 4068 in afpdlrh


Cause: afpdlrh failed due to ORA-04068: existing state of packages has
been discarded
ORA-04061: existing state of package body “APPS.FND_DCP” has been
invalidate




==========================================
Issue Resolution


1. Shut down the Concurrent manager completely using adcmctl.sh


cd $ADMIN_SCRIPTS_HOME


adcmctl.sh stop apps/<appspassword>


2. Compile the invalids in database


SQL>alter package FND_DCP compile body;


OR


Run the utlrp.sql script to recompile all the invalid objects in the database.


3. Startup Concurrent manager using adcmctl.sh


cd $ADMIN_SCRIPTS_HOME


adcmctl.sh start apps/<appspassword>


4. Verify Oracle EBS Concurrent manager is running fine.

Leave a Reply

Your email address will not be published. Required fields are marked *