My Oracle Support Banner

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

Last updated on JANUARY 29, 2021

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.