My Oracle Support Banner


Last updated on FEBRUARY 06, 2022

Applies to:

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


In 12.2.5, custom code is used to call the Public API CS_SERVICEREQUEST_PUB.CREATE_SERVICE_REQUEST and UPDATE_SERVICE_REQUEST which eventually calls packaged procedure CS_WF_AUTO_NTFY_UPDATE_PKG.SET_NOTIFICATION_DETAILS.The change in CS_WF_AUTO_NTFY_UPDATE_PKG.SET_NOTIFICATION_DETAILS for 12.2.3, now attempts to notify all members of the owning group of the Service Request, when an update to the SR has taken place.


In order to send a notification to all members of the owner group, CS_WF_AUTO_NTFY_UPDATE_PKG.SET_NOTIFICATION_DETAILS creates an adhoc role using the following code;


This sets the adhoc role name to a date & time stamped value, correct to the nearest second. Since this code is being called more than once per second, we are getting

Workflow Errors: SERVEREQ, 5068590-17492918-EVT
  Failed Activity Rules Defined For Event
  Activity Type Function
  Error Name -4061
  Error Message ORA-0461: existing stat of has been invalidated ORA-0461: existing state of package body "APPS.CS_WF_AUTO_NTFY_UPDATE_PKG" has been invalidated OrA-04065: not executed, altered or dropped package body "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, 5068590-17492918-EVT, 831055, RUN)


 When new profile"CS_SR_NTFY_GRP_MEM"No, means the offending code (that which generates the WF_DUP_ROLE error) is not executed.

Profile check added for bug 22227376:

-->     elsif l_owner_group_id is not null and nvl(FND_PROFILE.Value('CS_SR_NTFY_GRP_MEM'),'N') = 'Y' then

You can see the code fix done in the package body cswfautb.pls 120.21.12020000.4


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.