WF_DUP_ROLE Generated From CS_WF_AUTO_NTFY_UPDATE_PKG.SET_NOTIFICATION_DETAILS (Doc ID 2193915.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Symptoms

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;

 l_adhoc_role := 'CS_WF_GRP_OWR_DUMMY-'||'-'||TH_CHAR(SYSDATE, 'DDMMYYYYHH24MISS');

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)

Changes

 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

Cause

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