EMM: WORKFLOW NOTIFICATIONS NOT SAVING IN PT_WF_NOTFY_TBL DUE TO DUPLICATE KEY INSERT (Doc ID 2194227.1)

Last updated on OCTOBER 17, 2016

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms


WM_UTILITIES.WONotification.WONotification.OnExecute -- &oNotify = create PT_WF_NOTIFICATION:Notification(%UserId,
%Datetime, &sLanguageCd);

This is a problem in any process that is run for notifications. due to PEOPLECODE USING %Datetime. It does not use milliseconds, causing duplicate keys.
&mynotification = create PT_WF_NOTIFICATION:Notification(%UserId, %Datetime, %Language);

The bad %Datetime parameter in create PT_WF_NOTIFICATION:Notification is causing the workflow notifications not to be saved in the PT_WF_NOTFY_TBL table.
The (%UserId, %Datetime, %Language) parameter needs to be changed to (%UserId, %Date + %PerfTime, %Language)

This is happening in Maintenance Management as follows:

WM_UTILITIES.WONotification.WONotification.OnExecute -- &oNotify = create PT_WF_NOTIFICATION:Notification(%UserId,
%Datetime, &sLanguageCd);

A similar issue was fixed by Bug 17021331 for the EOAW_CORE.NotificationManager code by changing the parameter to (%UserId, %Date + %PerfTime, %Language)
instead of (%UserId, %Datetime, %Language).

See SR # 3-12690342381

The following SRs have been created to resolve this issue in all products:
3-12912516045 for eSettlements
3-12912516178 for Cash Management
3-12912516350 for Purchasing
3-12912516454 for PeopleTools
3-12912852041 for Asset Management
3-12912852057 for Maintenance Management
3-12912852371 for Expenses

Cause

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 hundreds of Community platforms