My Oracle Support Banner

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

Last updated on MAY 10, 2018

Applies to:

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


-- 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
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:


ORA-00918: column ambiguously defined




To view full details, 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 a vibrant support community of peers and Oracle experts.