EPY: Wrong Retropay Sequence Number in Pay Oth Earns - Resulting in 008019 'Retro Pay Request Not Found' Error Message (Doc ID 1982437.1)

Last updated on MARCH 06, 2017

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run the retro pay calculation, the following error occurs.

008019 - A Retro Pay Request for the sequence number on the paysheet's retro earnings could not be found. This could indicate a data corruption issue. Please check that the Retro Pay Sequence Number below belongs to a Retro Pay Request generated for this employee. If necessary, turn of the 'Ok To Pay' checkbox on this payline to remove the retro earnings from the paycheck.


1.) This error occurs for an employee who has a PS_PAY_OTH_EARNS.RETROPAY_SEQ_NO that is a different employees RETROPAY_SEQ_NO.
2.) The amount of the retropay is the correct amount, the RETROPAY_SEQ_NO is wrong.

Retro information is not correctly loaded into the right retro pay sequence numbers to the other earnings table (PS_PAY_OTH_EARNS) when an employee was transferred from another paygroup and he has a calculated retro pay from ONLY the prior paygroup.

Cause

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