INSERT-PYOERN(INSERT) 00805 error on Load Retro Pay to Paysheets. (Doc ID 608055.1)

Last updated on MAY 11, 2015

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

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