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

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Teleservice - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 15-May-2014***


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
The issue can be reproduced at will with the following steps:
1. Update SR
2. Save changes

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