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

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

PO_POCHNG is getting failed while processing VAT enabled change order.

Steps to reproduce the issue:

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. CAN01 and FRA01
3.Get the change request approved.
4.Run the PO_POCHNG process for both these change requests under same run control ID (ie., process should have run for selected business units CAN01 to FRA01.
5.Process goes to No Success with the below error in Message log -

Error
------
File: e:\pt85505c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 805 - [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the prima ry key, 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

 

 

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