My Oracle Support Banner

EAP: Payment Post / Voucher Post ABENDED at Step AP_PSTCOMMON.ACCOUNTS.Step05 with a "duplicate rows in a table with a UNIQUE index" Error. (Doc ID 622217.1)

Last updated on OCTOBER 29, 2018

Applies to:

PeopleSoft Enterprise FIN Payables - Version 7.5 and later
Information in this document applies to any platform.

Symptoms

Release 7.5x:
Payment Post / Voucher Post  receives  following unique constraint error:
(AP.APPSTCOM.ACCOUNTS.ACCT-5) (UPDATE), PTPEEXEC: 00805 INSERT or UPDATE would result in duplicate rows in a table with a UNIQUE index, Program(APPSTCOM), Application    ABENDED at step AP.APPSTCOM.ACCOUNTS.ACCT-5.  Return Code = 00805, Application Engine ABENDED at RTNCD=+000805

Release 8.x and higher:
Payment Post abends at AP_PSTCOMMON.ACCOUNTS.Step05.  Return Code = 00805

Education & Government : AP.APPSTCOM.PMTBAL.ACCT-5

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 
PAYMENT POST (APPSTPAY / AP_PSTPYMNT) Workaround:
 For Release 7.5x, 8 SP1/SP2/SP3 :
 For Release 8.4 and Above:
 VOUCHER POST (APPSTVCH / AP_PSTVCHR) :

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