EAP: Voucher Build Fails at Step LC_VATALGO.SHRNKAGE.Step01 (PeopleCode) with error "ORA-00001: unique constraint PS_TRT_APPRV_TAO5 violated" (Doc ID 1631186.1)

Last updated on SEPTEMBER 15, 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 at Step LC_VATALGO.SHRNKAGE.Step01 (PeopleCode)

ERROR:
Return:  805 ORA-00001:unique constraint (EMDBO.PS_TRT_APPRV_TAO5) violated Statement:

INSERT INTO PS_TRT_APPRV_TAO5 (PROCESS_INSTANCE, COUNTRY_LOC_SELLER,
COUNTRY_SHIP_FROM , COUNTRY_SHIP_TO, COUNTRY_VAT_BILLFR, COUNTRY_VAT_BILLTO,
COUNTRY_VAT_SHIPTO, COUNTRY_VAT_SUPPLY, D ROP_SHIP_FLAG, PHYSICAL_NATURE,
VAT_ADVPAY_FLG, VOUCHER_STYLE, VAT_TREATMENT, VAT_SUBJ_RVRSE_CHG, VA
T_RVRSE_CHG_GDS, MESSAGE_SET_NBR, MESSAGE_NBR, ERROR_FIELDNAME)

SQL error in Exec. (2,280) LC_UTILITIES.AE.insertSelectMgr.OnExecute Name:executeSQL PCPC:1071 Statement:16

Called from:LC_VAT_BV2.BatchContext.OnExecute Name:MoveToAlgo Statement:197

Called from:LC_VATALGO.SHRNKAGE.GBL.default.1900-01-01.Step01.OnExecute Statement:3

Process 819521 ABENDED at Step LC_VATALGO.SHRNKAGE.Step01 (PeopleCode) -- RC = 8 (108,524)

STEPS:
1) Create three Business Units (BUs) under UK VAT Entity
2) Enable Domestic reverse charge as Yes for two of the three BUs
3) Disable Vendor or Vendor Location VAT Defaults for 3 Vendors
4) Create three quick invoices one each for a Payables BU with a different Vendor
5) All quick invoices have multiple Voucher lines
6) Run Voucher build for All BUs, sources and interfaces

Process fails with the above error

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