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 MAY 26, 2017

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

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