Update Got Error ORA-04061: existing state of package has been invalidated (Doc ID 754861.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.