AP_PSTVCHR Fails With Unique Constraint Error At IU_PROCESSOR.U400.U400-010

(Doc ID 2350168.1)

Last updated on JANUARY 18, 2018

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue Statement:
AP_PSTVCHR fails with IU error

Steps:
  1: Run AP_PSTVCHR
 
  
Error:
01-AE_AP_PSTVCHR_1580675-Bad_Trace.AET.

-- 03.26.22 Process 1580675 ABENDED at Step IU_PROCESSOR.U400.U400-010 (Action SQL) -- RC = 805
ROLLBACK
/
-- 03.26.22 SQL Error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_VCHR_TEMP3_LN4' with unique index 'PS_VCHR_TEMP3_LN4'. The duplicate key value is (1580675, 287NO, 00000465, 0, AP_ACCRUAL, PPAY, 99998, 99999, 1, UNP

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