EEX 9.2: Workflow Notifications Not Saving In PS_PT_WF_NOTFY_TBL Due To Duplicate Key Insert (Doc ID 2180966.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

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

Symptoms

ISSUE:

A problem has been detected in the way PeopleSoft Enterprise FSCM Expenses module handles Workflow Notifications. The currently delivered codeline uses variable &mynotification (Local PT_WF_NOTIFICATION:Notification), which creates a Workflow Notification taking into consideration (%UserId, %Datetime, %Language). However, this logic is not taking into consideration milliseconds, and in occasions, this creates duplicate keys on some notifications.

This incorrect use of the variable parameters has been detected on Workflow Notifications for Time Report transactions, as well as DCCA Notifications.

REPLICATION STEPS:

     - Log into the Application Designer of an FSCM 9.2 Environment
     - Open delivered codeline within Record Field PeopleCode EX_TIME_HDR.TIME_SHEET_STATUS.Workflow
     - Notice the line of code: &mynotification = create PT_WF_NOTIFICATION:Notification(%UserId, %Datetime, %Language);
     - Open delivered codeline within Component PeopleCode EX_DCAA_ACKN.ACK_NTFY.GBL.default.1900-01-01.Sendmail.OnExecute
     - Notice the line of code: &mynotification = create PT_WF_NOTIFICATION:Notification(%UserId, %Datetime, %Language);
     - Open delivered codeline within Component PeopleCode EX_DCAA_CUTF.CUT_NTFY.GBL.default.1900-01-01.Sendmail.OnExecute
     - Notice the line of code: &mynotification = create PT_WF_NOTIFICATION:Notification(%UserId, %Datetime, %Language);

ACTUAL RESULT:

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.

EXPECTED BEHAVIOR:

The (%UserId, %Datetime, %Language) parameter needs to be changed to (%UserId, %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