My Oracle Support Banner

GP UK - RTI Process Calculation Error Due To Not Considering The EMP_RCD_ACUM (Doc ID 2420713.1)

Last updated on JULY 09, 2018

Applies to:

PeopleSoft Enterprise HCM Global Payroll UK - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

RTI process calculation error due to not considering the EMP_RCD_ACUM

For example,
If an employee is terminated on 30t June and a backdated entry had been keyed in to make the employee active for one more day. Now on the same day (30th June) the employee turned into Pensioner.
In payroll calculation we can see employee Gross NIABLE Accumulator is getting calculated correctly based on the Retro entry. However, while calculating the RTI it simply picks the MAX (SEQ_NUM8) without considering the EMP_RCD_ACUM field.
Because of which the calculation done for Gross NIABLE accumulator value is calculating wrong and fetching the value for calculation from Pensioner instead of Employee.
The issue happens in the following SQL , GPGB_RTI_PRC.RTI Acum.Step03

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.