My Oracle Support Banner

EAP9.2: Transaction Loader (FS_GSTUPDRPT) Process Fails with Unique Constraint Error at LC_GSTLOAD.INS_AP.Step01 (SQL) (Doc ID 2440252.1)

Last updated on FEBRUARY 08, 2019

Applies to:

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


When there are 2 vouchers with same voucher id but different business units are present in PS_VCHR_LN_EXS_DTL and Transaction Loader is executed for only one BU, then it is picking up the data of other BU as well. This results in either Unique Constraint Error or picking up of Excise / Sales Tax data.

1) Create 2 Vouchers for 2 different India Tax applicable BU's such that both Voucher Ids are same.
2) Post the Vouchers.
3) Run GST Transaction Loader process for one GL BU.

Expected result:
GST data should be loaded only for one voucher.

Actual result:
If India GST is applicable for both Vouchers  - it results in Unique Constraint Error.

If Excise / Sales Tax is applicable for one Voucher and GST is applicable for another - it results in Excise / Sales Tax row being picked up.




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

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