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

Last updated on SEPTEMBER 06, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, WORKFLOW NOTIFICATIONS NOT SAVING IN PT_WF_NOTFY_TBL DUE TO DUPLICATE KEY INSERT

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

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