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 184.108.40.206 [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:
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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!