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

Last updated on APRIL 04, 2025

Applies to:

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 reversal

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.