My Oracle Support Banner

EPY:Retro Pay Calculating On Prior Hourly Rate And Failing On Error 805 (Unique Constraint) (Doc ID 2615762.1)

Last updated on JULY 28, 2020

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.


On : 9.2 version, Core Processes

When attempting to calc retro pay
the following error occurs.

11:55:21.882 6991 0.000 0.000 #0 RC=805 ERR rtncd=805 msg=INSERT or UPDATE would result in duplicate rows in a table with a UNIQUE index
11:55:21.890 6992 0.016 0.000 #17 RC=0 EPO error pos=0
11:55:21.899 6993 0.000 0.000 #17 RC=0 Rollback
11:55:21.908 6994 0.015 0.015 #17 RC=0 Disconnect

The issue can be reproduced at will with the following steps:
1. give Tip employee an hourly rate increase
2. run retro pay calc
3. see results 9 employees did not work

Due to this issue, users cannot pay the retro owed to employees




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.