My Oracle Support Banner

EAP: Voucher Build ABENDED at Step APVEDTVLDT.MAIN.Step13 with Unique Constraint error (Doc ID 2245802.1)

Last updated on MAY 07, 2019

Applies to:

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

Symptoms

Voucher Build abends at Step APVEDTVLDT.MAIN.Step13 with an error if Voucher Build is rerun on Debit Memo Adjustment Voucher.

ERROR
-- 04:03:59.876 Process 73461 ABENDED at Step APVEDTVLDT.MAIN.Step13 (Action SQL) -- RC = 805
ROLLBACK
/
-- 04:03:59.939 SQL Error: ORA-00001: unique constraint (SYSADM.PS_AP_VCHRCVM_T4) violated

STEPS
1. Allow Debit Memo at Supplier
2. Enable Sales Tax at Supplier
3. Create Purchase Order with 2 lines
4. Remove 'Inspection Required' for both the lines
5. Create the PO and Enable Matching
6. Sales Tax will get defaulted from Supplier
7. Fully Receive the PO
8. Create the PO Voucher
9. Increase the Unit price of Invoice line 1 from 35 to 45.
   Change the Invoice Total from 55 to 70
   Add Freight >> 2.24
   Sales Tax >> 2.76.
10. Save the Voucher and Run Matching
11. Exceptions Occurred
    Click on Exceptions Hyperlink
12. Open Period is from 01/01/2017
      Update the Accounting Date as 23-Sep-2016
13. Override the Exceptions with Debit Memo when applicable
14. Run the Matching and it will auto trigger Voucher Build
15. Adjustment Voucher is created
16. Run Voucher Build again for Business Unit US001 and Voucher Source as 'All (Unrestricted)'
17. Voucher Build failed

Attached are the Replication Steps

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
References


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