Update Got Error ORA-04061: existing state of package has been invalidated
(Doc ID 754861.1)
Last updated on JULY 06, 2020
Applies to:Oracle Shipping Execution - Version 18.104.22.168 and later
Information in this document applies to any platform.
Oracle Shipping Delivery Based - Version: 22.214.171.124
In release 126.96.36.199 when adding a new address to an existing customer, the sysadmin sends a notification of errors to the System Administrator, however in the application the newly created address is visible and working.
The errors seen by the System Administrator are the following:
Event oracle.apps.ar.hz.Location.create errors with:
Event Error Name: WFE_DISPATCH_RULE_ERR
Event Error Message 3825: Error-4061-ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package "APPS.WSH_MAP_LOCATION_REGION_PKG" has been invalidated ORA-06508: PL/SQL could not find program unit being called" encountered during execution of Rule function 'WSH_MAP_LOCATION_REGION_PKG.Rule_Location' for event 'oracle.apps.ar.hz.Location.create; with key
Event Error Stack
This issue is addressed in Bug/Patch 7129449 that contains the following files and version numbers:
WSH_MAP_LOCATION_REGION_PKG WSHMLORS.pls 115.10.11510.5
WSH_MAP_LOCATION_REGION_PKG WSHMLORB.pls 115.32.11510.18
However, even after the application of the patch the issue is not resolved. The package body and specs show as valid.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document