EBI 9.2: Billing Interface Process Is Failing With Unique Constraint (SYSADM.PS_VRGBFSA_TAO4) Violated
(Doc ID 2550874.1)
Last updated on FEBRUARY 21, 2023
Applies to:
PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
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.
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 |