EPY: " ORA-00001: UNIQUE CONSTRAINT" Error on PS_PAY_TAX for Manual Check with Pennsylvania Locals (Doc ID 2004393.1)

Last updated on OCTOBER 23, 2015

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9 and later
Information in this document applies to any platform.

Goal

When attempting to back out a confirmed on-cycle check using a manual check process, the process abends if the employee has multiple Pennsylvania localities:

 

Application Program Failed

 In Pgm Section  : INSERT-PAY-TAX                                                                                                                                              

 With Return Code: 00805

 Error Message   : ORA-00001: unique constraint (EMDBO.PS_PAY_TAX) violated

 

Solution

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