My Oracle Support Banner

EAP: Voucher Build (AP_VCHRBLD) Fails with Unique Constraint Error at Step AP_VB_STGVCH.STGVCHR.Step05 (Action SQL) (Doc ID 1954872.1)

Last updated on FEBRUARY 21, 2023

Applies to:

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


Voucher Build fails with Unique Constraint error.

1) Load data into VCHR_HDR_STG, VCHR_LINE_STG and VCHR_DIST_STG from External System.
2) Run Voucher Build process to load the vouchers from Staging.

Error message:
-- 12.39.57 Process 238779 ABENDED at Step AP_VB_STGVCH.STGVCHR.Step05 (Action SQL) -- RC = 805
-- 12.39.57 SQL Error: ORA-00001: unique constraint (SYSADM.PS_VCHR_HDR_TMP4) violated


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

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