Workflow Notifications Not Saving In PT_WF_NOTFY_TBL Due To Duplicate Key Insert (Doc ID 1579279.1)

Last updated on JUNE 15, 2017

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Workflow Notifications Not Saving in PT_WF_NOTFY_TBL Due to Duplicate Key Insert.

If multiple email notifications are being sent out at the same time, entries aren’t being inserted into the PT_WF_NOTFY_TBL table after the first row is inserted. This issue is due to the key structure in this table as the only keys are CREATEOPRID, CREATEDTTM and LANGUAGE_CD so if the CREATEDTTM is the same time for the following entries they don’t get inserted.
This was an issue that was fixed in the Enterprise Component (EC) Bundle 3 (<Bug 11622589>), but then broke again in Enterprise Component Bundle 4.
The code fix included in EC Bundle 3 was code added to EOAW_CORE.NotificationManager.Notify (App Pkg PC) that adds milliseconds to be included in the CREATEDTTM field.
Code before and after EC Bundle 3 that is causing the issue:
&Notification = create PT_WF_NOTIFICATION:Notification(&from, %Datetime, %Language);

Code included in EC Bundle 3 that resolved the issue:
&Notification = create PT_WF_NOTIFICATION:Notification(&from, %Date + %PerfTime, %Language);

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