EPY: Payroll Process Fails With Error 805 - Unique Constraint (PRIMARY SOLUTION)
(Doc ID 607013.1)
Last updated on APRIL 11, 2024
Applies to:
PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9] Information in this document applies to any platform.
Purpose
This is a "living document" which is updated whenever new information is available.
A unique constraint error means that an attempt has been made to insert a record with a duplicate key structure of an existing record. This error can also be generated if an existing record is updated to generate a duplicate key.
The error message and text can vary by Platform/RDBMS -- Here are some of the variations:
RDBMS
MESSAGE # / ID
MESSAGE TEXT
Oracle
ORA-00001
"Unique Constraint Violated" "Duplicate Key in Index"
SQL Server
805 / 000805
non-unique data
DB2
SQLCode -302
Insert/Update of unique constrained columns with duplicate data
Allbase
2509
Index uniqueness or unique/primary key constraint violated
RDB
-803: %RDB-E-NO_DUP
Index field value already exists; duplicates not allowed for Unique Index
Join our growing North American Payoll Community on My Oracle Support. We encourage you to review, join, or start a discussion.
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
