Service: Error In Workflow When Service Request Is Updated: ORA-04061 (Doc ID 357816.1)

Last updated on AUGUST 15, 2023

Applies to:

Symptoms

When attempting to update a Service Request, the following error occurs:

ERROR
Workflow Errors: SERVEREQ, 458-190-EVT

Failed Activity Rules Defined For Event

Activity Type Function

Error Name -4061

Error Message ORA-04061: existing state of has been invalidated ORA-04061:
existing state of package body "APPS.CS_WF_ACTIVITIES_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package body
"APPS.CS_WF_ACTIVITIES_PKG" ORA-06508: PL/SQL: could not find program unit
being called

Error Stack
Wf_Engine_Util.Function_Call(CS_WF_ACTIVITIES_PKG.SERVEREQ_SELECTOR, SERVEREQ,
458-190-EVT, TEST_CTX) Wf_Engine_Util.Execute_Selector_Function(SERVEREQ,
458-190-EVT, TEST_CTX)
Wf_Engine_Util.Function_Call(CS_WF_AUTO_NTFY_UPDATE_PKG.CHECK_RULES_FOR_EVENT,
SERVEREQ, 458-190-EVT, 147843, RUN)

Error Name = -4061
Error Message = ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "APPS.CS_STD" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.CS_STD"
Error Stack =
CS_WF_AUTO_NTFY_UPDATE_PKG.Get_Request_Attributes(SERVEREQ, 10249-7763-EVT, 205676, RUN)
Wf_Engine_Util.Function_Call(CS_WF_AUTO_NTFY_UPDATE_PKG.GET_REQUEST_ATTRIBUTES, SERVEREQ, 10249-7763-EVT, 205676, RUN)

Activity Id = 205676
Activity Label = CSEVTPROC:GET_REQUEST_ATTRIBUTES
Result Code = #EXCEPTION
Notification Id =
Assigned User =



Steps:

1. Update SR
2. Save changes

Changes

Cause

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