Workflow Error -Item Type = SERVEREQ (Doc ID 2120386.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run workflow the following error occurs:

Error:

An Error occurred in the following Workflow.

Item Type = SERVEREQ
Item Key = 1169804-2619021-EVT
User Key =

Error Name = -4061
Error Message = ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package "APPS.CS_WF_AUTO_NTFY_UPDATE_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "APPS.CS_WF_AUTO_NTFY_UPDATE_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.CS_WF_AUTO_NTFY_UPDATE_PKG"
Error Stack =
Wf_Engine_Util.Function_Call(CS_WF_AUTO_NTFY_UPDATE_PKG.CHECK_RULES_FOR_EVENT, SERVEREQ, 1169804-2619021-EVT, 267768, RUN)

Activity Id = 267768
Activity Label = CSEVTPROC:CHECK_RULES_FOR_EVENT
Result Code = #EXCEPTION
Notification Id =
Assigned User =

WHEN THIS STARTED
----------------
Issue started this weekend after applying below patches in ERP Prod:

15842993:R12.ONT.B
17050135:R12.PO.B - In Oracle Purchasing, Searching for Quotations by the RFQ number was not retrieving any results.
19663699:R12.PO.B - In Oracle Purchasing, user can load price breaks with no ship to organization using Import Price Catalogs
17956894:R12.INV.B - ERROR IN TMO - VIEW / UPDATE ALLOCATIONS FORM
19597452:R12.INV.B - In Oracle Inventory Management, it fails to do MSCA deliver against PO receipt with lot controlled item without revision control. This patch fixes the issue.
17207059:R12.INV.B
21218468 - R12.INV.B.delta.12 - Inventory Consolidated RUP12 (VERSION 12.1.1 TO 12.1.3 [RELEASE 12.1])
22120593:R12.CSD.B - ORACLE DEPOT REPAIR RECOMMENDED PATCH COLLECTION (08-DEC-15)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Workflow

BUSINESS IMPACT
---------------
Many users are impacted.
This is not complete loss of service, but Workflow going in error status and business is not able to proceed.

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