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.

Symptoms

On : 9.2 version, Core Processes

When attempting to calc retro pay
the following error occurs.

ERROR
-----------------------
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


STEPS
-----------------------
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

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.