RetroNotifications Report Not Consistant On UDT Values Update For Correction And Update
Last updated on JANUARY 12, 2017
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
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. Create a UDT
- Create the triggers and event group for the UDT in Correction / Update
- Run Retro Notification report
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