ASO Approval Workflow Errors Out With 'ORA-04061: Existing State of Has Been Invalidated' Message
(Doc ID 376783.1)
Last updated on MAY 10, 2022
Applies to:Oracle Quoting - Version 22.214.171.124 to 126.96.36.199 [Release 11.5.10]
Information in this document applies to any platform.
Status Monitor shows ASO Approval Workflow with errors.
Failed Activity NOTIFY_SENDER
Activity Type Function
Error Name -4061
Error Message ORA-04061: existing state of has been invalidated ORA-04061:
existing state of package "APPS.ASO_APR_WF_PVT" has been invalidated ORA-04065:
not executed, altered or dropped package "APPS.ASO_APR_WF_PVT" ORA-06508:
PL/SQL: could not find program unit being called
Error Stack Wf_Engine_Util.Function_Call(ASO_APR_WF_PVT.SEND_NOTIFICATION,
ASOAPPRV, 20187DET, 171792, RUN)
The issue can be reproduced at will with the following steps:
1. Login as user sysadmin
2. Access Status Monitor
3. Do a query,the parameter is:
Workflow Type: ASO Approval
Type Internal Name: ASOAPPRV
Workflow Status : Error
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