Last updated on OCTOBER 25, 2016
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;
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)
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms