Oracle.Apps.Ar.Hz.Location.Update Got Error ORA-04061: existing state of package has been invalidated (Doc ID 754861.1)

Last updated on JULY 25, 2016

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
Oracle Shipping Delivery Based - Version: 11.5.10.2

***Checked for relevance on 14-Jan-2015***


Symptoms

In release 11.5.10.2 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
'oracle.apps.ar.hz.Location.createxxxx'
Event Error Stack
Wf_Eventdispatch_internal()

Changes

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.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms