UK Pay: Retropay is Incorrect For Niable Pay_PER_NI_PTD
(Doc ID 2299568.1)
Last updated on FEBRUARY 20, 2019
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
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