UK Pay: Retropay is Incorrect For Niable Pay_PER_NI_PTD

(Doc ID 2299568.1)

Last updated on AUGUST 22, 2017

Applies to:

Oracle HRMS (UK) - Version 12.1 and later
Information in this document applies to any platform.


Problem Statement:

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