My Oracle Support Banner

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 JULY 10, 2020

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

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.