My Oracle Support Banner

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 OCTOBER 26, 2018

Applies to:

Oracle iProcurement - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


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

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
Symptoms
Changes
Cause
Solution

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