EBI 9.2: Billing Interface Process Is Failing With Unique Constraint (SYSADM.PS_VRGBFSA_TAO4) Violated (Doc ID 2550874.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Symptoms

On : 9.2 PUM 20 version, Billing Interface

When attempting to run VAT default process ( BIPVAT000) the following error occurs.

ERROR
-----------------------
In FS_VATDFLTS.SETDFLTS, Step INI (999,99)

SQL error. Function: SQLExec
  Error Position: 0
  Return: 805 - ORA-00001: unique constraint (SYSADM.PS_VRGBFSA_TAO4) violated
  Statement: INSERT INTO PS_VRGBFSA_TAO4 (PROCESS_INSTANCE, COUNTRY_LOC_BUYER, COUNTRY_LOC_SELLER, COUNTRY_SHIP_FROM, COUNTRY_SHIP_TO, COUNTRY_VAT_BILLTO, COUNTRY_VAT_PERFRM, PHYSICAL_NATURE, VAT_SERVICE_TYPE, VAT_SVC_SUPPLY_FLG, DROP_SHIP_FLAG, VAT_ENTITY, COUNTRY_VAT_BILLFR, VAT_RPT_CNTRY_SRC, ERROR_FLAG, MESSAGE_SET_NBR, MESSAGE_NBR, ERROR_FIELDNAME, CUST_ID, CUSTOMER_SETID, VAT_RGSTRN_BUYER) SELECT DISTINCT PROCESS_INSTANCE, COUNTRY_LOC_BUYER, COUNTRY_LOC_SELLER, COUNTRY_SHIP_FROM, COUNTRY_SHIP_TO, COUNTRY_VAT_BILLTO, COUNTRY_VAT_PERFRM, PHYSICAL_NATURE, VAT_SERVICE_TYPE, VAT_SVC_SUPPLY_FLG, 'N', VAT_ENTITY, ' ', ' ', ERROR_FLAG, MESSAGE_SET_NBR, MESSAGE_NBR, ERROR_FIELDNAME, CUST_ID, CUSTOMER_SETID, VAT_RGSTRN_BUYER FROM PS_G1INTFCBITAO4 WHERE MESSAGE_NBR = 0 AND PROCESS_INSTANCE = 16290404
  Original Statement: %InsertSelect( DISTINCT, VRGBFSA_TAO,G1INTFCBITAO , COUNTRY_VAT_BILLFR = ' ', DROP_SHIP_FLAG = 'N', VAT_RPT_CNTRY_SRC = ' ') FROM %table(G1INTFCBITAO) where MESSAGE_NBR = 0 AND PROCESS_INSTANCE = 16290404

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 16290404 ABENDED at Step LC_VATALGO.SHRNKAGE.Step01 (PeopleCode) -- RC = 8 (108,524)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Interface jobs for all business units which are VAT enabled where multiple Bill to Cust ID's.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot apply VAT to bills using interface.

Cause

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