Hi All, Its version 11.2.0.4 of oracle and we are seeing below error intermittently. Its causing the corresponding job to be failed but then when we rerun it gets auto compiled and run successfully without any intervention. So wanted to understand the cause and how can we find that out?
I don't find any much clue from the dba_objects as i see many objects showing at top as their last_ddl_time and are not referred in this package, so wondering how to get the root cause and fix for this.
ORA-04061: existing state of package "SCHEMA1.APP_PKG1" has been invalidated
ORA-04065: not executed, altered or dropped package "SCHEMA1.APP_PKG1"