Oracle.Apps.Ar.Hz.Location.Update Got Error ORA-04061: existing state of package has been invalidated
Last updated on FEBRUARY 07, 2018
Applies to:Oracle Shipping Execution - Version 22.214.171.124 to 126.96.36.199 [Release 11.5.10]
Information in this document applies to any platform.
Oracle Shipping Delivery Based - Version: 188.8.131.52
***Checked for relevance on 14-Jan-2015***
In release 184.108.40.206 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms