EAP: Unique Constraint Error With Voucher Build Apvedtvldt.Main.Step13

(Doc ID 2245802.1)

Last updated on MARCH 20, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Issue Statement:
Unique constraint error in Voucher Build while producing Debit Memo

Steps:
  1: Create a 2 line PO having Sales and Use Tax
  2: Receive the PO fully
  3: Create a PO voucher with this PO and increase the Unit price
  4: Run matching and override the Exception using action as Debit Memo
  5: Update the Accounting date of the Regular voucher to a date in closed period.
  6: Run the matching that created Debit Memo in Recycled status
  7: Run Voucher Build
  
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

Replication Steps

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