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 JANUARY 12, 2024

Applies to:

PeopleSoft Enterprise FIN Payables - Version 7.5 to 9.2 [Release 7.5 to 9]
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 / Voucher Post abended at AP_PSTCOMMON.ACCOUNTS.Step05.  Return Code = 00805

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

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

Cause

Solution

WORKAROUND

Note: Before committing any changes, run the SQL statements in a test environment first. If additional assistance is needed, create a Service Request.

PAYMENT POST (APPSTPAY / AP_PSTPYMNT):

For Release 8.4 and Above:

For Release 7.5x, 8 SP1/SP2/SP3:

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.

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)

Applies to:

Symptoms

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!