My Oracle Support Banner

RetroNotifications Report Not Consistant On UDT Values Update For Correction And Update (Doc ID 1457170.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

This note provides a brief overview of


Problem Statement:

When updating a UDT in update mode, Retro Notification Report picks up employee records but when the same record is changed to correction after running payrolls and first retropay by element, Retro Notification Report does not pick up the employee again. Checked pay_process_events events table and events are being generated both for UDT and global values.

We cannot use any of the enhanced version of retronotifications report since we do not have enhanced retropay enabled for international HRMS. This is because retronotifications enhanced updates the tables PAY_RETRO_EVENTS and PAY_RETRO_ASSIGNMENTS.  The last version of Retro-Notifications Report is the one that needs to be used for Retropay by element process since the notifications report creates an assignment set which then is used by Retropay by element process to further take action on the employees under the assignment set created by the notifications report.

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1. 1. Create a UDT
  2.  Create the triggers and event group for the UDT in Correction / Update
  3. Run Retro Notification report




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

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