Its version 11.2.0.4 of Oracle. We are getting below error from multiple sessions at certain point in time. And then at later stage all seems work fine. So we are hitting this error intermittently across multiple connected sessions. As per this error description somewhere , some dependent object of this package got altered causing this package to go invalid, but this environment is a controlled environment, and we were not able to identify the root cause of this issue? Wanted to understand if there is other way to debug this error systematic way and finding the root cause of this error? or If session trace(10046 trace) of the failed session will help us anyway to get any hints regarding the cause ?
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "USER1.Custom_Rep_Pkg"
ORA-06508: PL/SQL: could not find program unit being called: "USER1.Custom_Rep_Pkg"
ORA-06512: at line 1