My Oracle Support Banner

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.


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


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.