EPY: Payroll Process Fails With Error 805 - Unique Constraint (PRIMARY SOLUTION)
(Doc ID 607013.1)
Last updated on AUGUST 17, 2021
PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9] Information in this document applies to any platform.
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:
MESSAGE # / ID
"Unique Constraint Violated" "Duplicate Key in Index"
805 / 000805
Insert/Update of unique constrained columns with duplicate data
Index uniqueness or unique/primary key constraint violated
Index field value already exists; duplicates not allowed for Unique Index