UK Pay: Retropay is Incorrect For Niable Pay_PER_NI_PTD
Last updated on AUGUST 22, 2017
Applies to:Oracle HRMS (UK) - Version 12.1 and later
Information in this document applies to any platform.
The Niable Pay_PER_NI_PTD is calculated incorrectly. This is because when calculating NI, the where clause used to sum the run_result_values related to the various assignment_actions has an incorrect where clause.
Depending on how the balance/dimension is invoked depends as to the exact construct of the SQL. But essentially it is the following piece of code:
'and PPTP.regular_payment_date >= l_stat_period_start'
This statement results in the retrieval all assignment actions which are after the regular payment date. Although in a normal Payroll Run this does not cause an issue, during the Retropay process this results in an incorrect NI value held in memory which affects the Net_Pay value and effects all elements that are related to this net_pay value resulting in incorrect Arrears calculations.
The correct pseudo logic should be:
where "Regular Payment Date" >= Statutory Period Start Date and "Regular Payment Date" <= Statutory Period End Date
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Run Retropay Enhanced and check the results
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