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 MAY 17, 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 Build fails with Unique Constraint error.

Steps:
----------
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
ROLLBACK
/
-- 12.39.57 SQL Error: ORA-00001: unique constraint (SYSADM.PS_VCHR_HDR_TMP4) violated


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