EAP : Voucher Build (AP_VCHRBLD) Process Goes To No Success With Error "ORA-00001: unique constraint (SYSADM.PS_TRT_APPRV_TAOx)" On LC_UTILITIES.AE.insertSelectMgr.OnExecute Name:executeSQL PCPC:1071 Statement:16 (Doc ID 2917888.1)

Last updated on DECEMBER 27, 2022

Applies to:

Symptoms

Voucher Build (AP_VCHRBLD) process going into No Success with below error:

Setup:
1. Navigate to Set Up Financials/Supply Chain > Common Definitions > VAT and Intrastat > Value Added Tax > VAT Country Options.
2. Enable Apply Domestic Reverse Charge in VAT country options.
3. Navigate to Set Up Financials/Supply Chain > Business Unit Related > Payables > Payables BU Processing Options.
4. Open the BU of same country, go to Tax options(tab) and click on VAT defaults links - Make sure the Domestic Reverse Charge set to "Yes".

Steps:
1. Navigate to Purchasing > Purchase Orders > Add/Update POs > Maintain Purchase Order - Purchase Order.
2. Create a Purachse Order and dispatch it.
3. Navigate to Accounts Payable > Vouchers > Add/Update > Quick Invoice Entry > Quick Invoice.
4. Create Quick invoice by copying Purachse Order created in Step 2.
5. Create another quick invoice for same Busienss Unit and Supplier but without the PO.
6. Navigate to Accounts Payable > Batch Processes > Vouchers > Voucher Build > Voucher Build
7. Run voucher build process.

Cause

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