ORA-04061:Existing State Of Package Body PO_REQAPPROVAL_LAUNCH Has Been Invalidated When Attempting To Approve Requisitions (Doc ID 339461.1)

Last updated on APRIL 18, 2023

Applies to:

Symptoms

Using release 11.5.9, the patch 3697659 UNEXPECTED ERROR WHEN RESPONDING TO MORE INFORMATION FUNCTIONALITY has been applied and now the requisitions are moving to status 'IN PROCESS' and the following error is being encountered:

ERROR
-------------------
WF_ERROR] ERROR_MESSAGE=3835: Error '-4061 - ORA-04061: existing state of has
been invalidated ORA-04061: existing state of has been invalidated ORA-04061:
existing state of package body "APPS.PO_REQAPPROVAL_LAUNCH" has been
invalidated ORA-04065: not executed, altered or dropped package body
"APPS.PO_REQAPPROVAL_LAUNCH" ORA-06508: PL/SQL: could not find program unit
being called' encountered during execution of Generate function
'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK=
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR, REQAPPRV,
275914-598391, TEST_CTX)
Wf_Engine_Util.Execute_Selector_Function(REQAPPRV,275914-598391, TEST_CTX)
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR, REQAPPRV,
275914-598391, TEST_CTX)
Wf_Engine_Util.Execute_Selector_Function(REQAPPRV,275914-598391, TEST_CTX)
Wf_Engine.CB(TESTCTX, REQAPPRV:275914-598391:145814,::::)
Wf_Engine.oldCB(TESTCTX, REQAPPRV:275914-598391:145814, ::::)
WF_MAIL.SetContext(722626) WF_XML.GenerateDoc(oracle.apps.wf.notification.send,722626) WF_XML.Generate(oracle.apps.wf.notification.send, 722626)
WF_XML.Generate(oracle.apps.wf.notification.send, 722626)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 722626, WF_XML.Generate)
Wf_Event.dispatch_internal()

STEPS
-------------------
1. Create a requisition using the iProcurement and submit for approval.
2. The requisition will remain IN PROCESS and an error is encountered during the approval process.

A notification is sent to the System Administrator - with the full error message listed.

Changes

Patch 3697659  UNEXPECTED ERROR WHEN RESPONDING TO MORE INFORMATION FUNCTIONALITY

This problem however may not be limited to the patch application.

Cause

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