ORA-04061: existing state of has been invalidated
(Doc ID 2515956.1)
Last updated on OCTOBER 10, 2022
Applies to:
Oracle iProcurement - Version 12.2.4 and laterOracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
Symptoms
On : 12.2.4 version, Approval List and Workflow
When attempting to approve a PR, the following error occurs:
ERROR
-----------------------
ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "APPS.PO_REQAPPROVAL_INIT1" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.PO_REQAPPROVAL_INIT1"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.PO_REQAPPROVAL_INIT1"
-----------------------
ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "APPS.PO_REQAPPROVAL_INIT1" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.PO_REQAPPROVAL_INIT1"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.PO_REQAPPROVAL_INIT1"
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Workflow Administrator
2. Open the Activities for one PR
3. See the error
Changes
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 |