EPY:PSPPYREV Errors With ORA-00001: Unique Constraint (PS_PAY_TAX_1042) Violated (Doc ID 1674004.1)

Last updated on JANUARY 14, 2016

Applies to:

PeopleSoft Enterprise HRMS Payroll for North America - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run Reversal check process. The Reverse process errors out.
 
The following error occurs:

ERROR
-----------------------
 PeopleSoft Payroll -- Version 9.0
Copyright (c) 1988-2004 PeopleSoft, Inc.
All Rights Reserved
 
Pay Reversal started for Company: XXX    Pay End Date: 2014-05-17
 at 13:37:45.79.
Start processing at 13:37:46.46.
FORMID=ADVICE,PAYCHECK_NBR=00000000XXXXXXX,CHECKDT=2014-05-09,EMPLID=XXXX,DELETE=N
 
Application Program Failed
 In Pgm Section  : UPDATE-PAY(INS TXN)                                 
 With Return Code: 00805
 Error Message   : ORA-00001: unique constraint (SYSADM.PS_PAY_TAX_1042) violated
 
 
Application Program Failed
 In Pgm Section  : PROCESS-REVERSAL(PSPCKREV)    With Return Code: 00805
 Error Message   : ORA-00001: unique constraint (SYSADM.PS_PAY_TAX_1042) violated
 
Pay Reversal did not finish at 13:37:49.57 !!!!!


 
 
BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, the end user cannot proceed with their check reveral

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