Recently one of our technical analyst came across error
ORA-04061: existing state of has been invalidated ORA-04061: existing state of package body "XXEORA.XXEORA_OM_DETAILS_PKG" has been invalidated
But when we look into our database package "XXEORA.XXEORA_OM_DETAILS_PKG" everything looks normal and
Select status from all_objects
where object_name = 'XXEORA.XXEORA_OM_DETAILS_PKG'
was returning Valid status.
NOTE - This database package was called from Oracle workflow.
I did quick research and found that , in such scenarios , it was advisable to
1. bouncing middle tier services
2.recompile the package
3.restarting the notification mailer resolve this issue