CS_WF_ACTIVITIES_PKG Invalid Package With "ORA-00918: column ambiguously defined" (Doc ID 464633.1)

Last updated on MAY 29, 2017

Applies to:

Oracle Teleservice - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 29-Jun-2017***


Symptoms

-- Problem Statement:
Find that the following notification message is received every time a service request is updated:

An Error occurred in the following Workflow.

Item Type = SERVEREQ
Item Key = 10646-55023-EVT
User Key =

Error Name = -4063
Error Message = ORA-04063: has errors
ORA-04063: package body "APPS.CS_WF_ACTIVITIES_PKG" has errors
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, 10646-55023-EVT, TEST_CTX)
Wf_Engine_Util.Execute_Selector_Function(SERVEREQ, 10646-55023-EVT, TEST_CTX)
Wf_Engine_Util.Function_Call(CS_WF_AUTO_NTFY_UPDATE_PKG.CHECK_RULES_FOR_EVENT, SERVEREQ, 10646-55023-EVT, 136312, RUN)

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



As the notification mentions, package APPS.CS_WF_ACTIVITIES_PKG might be invalid, with the following error being reported at compiling the CS_WF_ACTIVITIES_PKG package body:

ERROR

ORA-00918: column ambiguously defined

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