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

Last updated on NOVEMBER 16, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

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)

IT_AGING.BusinessObjects.AgingNotification.OnExecute -- %This.AgingNotification = create PT_WF_NOTIFICATION:Notification(%UserId, %Datetime, %Language);

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).

Request a fix for the above AM code as well.

 

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