PO_POCHNG Is Getting Failed While Processing VAT Enabled Change Order (Doc ID 2279976.1)

Last updated on JUNE 23, 2017

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Change Request

Change purchase order process - PO_POCHNG is getting failed while processing VAT enables change order

ERROR
-----------------------
unique constraint or unique index identified by "1" constrains Failed SQL stmt: INSERT INTO PS_PO_VC_OUT_T4 ( PROCESS_INSTANCE, BUSINESS_UNIT, PO_ID, PO_STG_TYP E, PO_STG_ID, LINE_NBR, SCHED_NBR, DISTRIB_LINE_NUM , VAT_ENTITY, VAT_ENVIRONMENT, VAT_RCRD_INPT _FLG, VAT_RCRD_OUTPT_FLG, VAT_DCLRTN_POINT, VAT_CALC_FRGHT_FLG, VAT_CALC_GROSS_NET, VAT_CALC_MISC_FL G, VAT_RECALC_FLG, VAT_EXCPTN_TYPE, VAT_EXCPTN_CERTIF, STATE, COUNTRY_SHIP_TO, COUNTRY_SHIP_FROM, CO UNTRY_VAT_BILLTO, COUNTRY_VAT_BILLFR, COUNTRY_VAT_SHIPTO, VAT_RGSTRN_SELLER, VAT_TXN_TYPE_CD, VAT_AP


The issue can be reproduced at will with the following steps:
1. Place the change request on tow requisitions for the countries which are VAT enabled.
2. Ensure that you are opting two different VAT enables counties. e.g. AUS01 and FRA01
3. Get the change request approved.
4. Run the PO_POCHNG process for both these change requests under same run control ID. Mean the process should have run for selected business units CAN01 to FRA01.
5. Process will get fail with the unique constraint violation at the step-

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