EAP: Voucher Posting abends at Step AP_PSTVCHR.AI000.AI000-2 (Action SQL) with Unique Constraint error (Doc ID 1629809.1)

Last updated on MARCH 18, 2016

Applies to:

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

Symptoms

Voucher Posting abends at Step AP_PSTVCHR.AI000.AI000-2 (Action SQL) with an error when posting a Voucher which was unposted using the Voucher Mass Maintenance page.

ERROR
Process 7059561 ABENDED at Step AP_PSTVCHR.AI000.AI000-2 (Action SQL) -- RC = 805
ROLLBACK
/
-- 15.04.27 SQL Error: ORA-00001: unique constraint (SYSADM.PS_PST_VCHR_TAO7) violated

STEPS
1) Create a Voucher and post it
2) Unpost the Voucher using Voucher Mass Maintenance
3) Make any change to the Voucher.  For example, change the Accounting Date.
4) Run Voucher Posting
5) Process will abend with the above error

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