EPY: Tax951ld Errors With Unique Constraint Due To EE's In Multiple Companies

(Doc ID 2368007.1)

Last updated on MARCH 01, 2018

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.

Symptoms


When attempting to Load 1042-S, the following error occurs.

ERROR
-----------------------
TAX951LD, Insert Error - Insert-YE-Employee Key Values: TABLE: PS_PY_1042S_YE_EE, TAX YEAR:2017, EMPLID:999999, PY_EE_SEQ_NO:1 Error : ORA-00001: unique constraint (PS_HR.PS_PY_1042S_MSG) violated

Due to this issue, users cannot run Year end load

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