Wednesday, December 27, 2017

Error Message: ORA-04061: existing state of has been invalidated

Issue:
Error Message: ORA-04061: existing state of has been invalidated ORA-04061: existing state of has been invalidated ORA-04061: existing state of package "APPS.GL_WF_JE_APPROVAL_PKG" has been invalidated ORA-04065: not executed, altered or dropped package "APPS.GL_WF_JE_APPROVAL_PKG" ORA-06508: PL/SQL: could not find program unit being called: "APPS.GL_WF_JE_APPROVAL_PKG


Resolution:

Please follow the below process to fix the issue .

Step - 1

Shutdown the concurrent manager

Step-2 

Recompile GL_WF_JE_NOTIFICATION_PKG

Step-3

E.g.

sqlplus apps/apps

SQL>alter package GL_WF_JE_NOTIFICATION_PKG complie;
SQL>alter package GL_WF_JE_NOTIFICATION_PKG compile body;

Step-4

Restart the concurrent manager

Step-5

Run the Journal apporval process