EPY:INSERT-PYOERN(INSERT) 00805 Error on Load Retro Pay to Paysheets.
(Doc ID 608055.1)
Last updated on APRIL 11, 2024
Applies to:
PeopleSoft Enterprise HCM Payroll for North America - Version 9 to 9.1 [Release 9]Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 186273
Symptoms
ISSUE 1
Getting error On-Cycle PaySheet Update started for Run: B06
at 17:31:00.71.
INSERT-PYOERN(INSERT) 00805 INSERT or UPDATE would result in duplicate rows in a table with a UNIQUE index when loading Retro pay to paysheets
ISSUE 2
When running the Retropay Load to Paysheets process (PSRPPSH), the process fails with the following error:
Application Program Failed
In Pgm Section : INSERT-PYOERN(INSERT)
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_OTH_EARNS) violated
ISSUE 3
When running the Retropay Load to Paysheets process (PSRPPSH), the process fails with the following error:
Application Program Failed
In Pgm Section : INSERT-PYOERN(INSERT)
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_OTH_EARNS) violated
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 |
| Cause |
| Solution |