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
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.
You could definitely see your expertise in the work you write. The world hopes for even more passionate writers like you who are not afraid to say how they believe. Always go after your heart.