My Oracle Support Banner

Edidlinv Batch Generating Wrong Flat File When RTV's With Multiple Tax Rates (Doc ID 1945356.1)

Last updated on MARCH 10, 2019

Applies to:

Oracle Retail Invoice Matching - Version 11.0 and later
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

Edidlinv batch generating wrong flat file, when Return To Vendor (RTV)'s with multiple tax rates is processed.When attempting to upload the same ,wrong Electronic Data Interchange(EDI) file  the following error occurs.


Steps To Recreate:

1. Created an RTV for 3 item, all three items belong to different vat rates.
2. Ship the RTV.
3. Run edidlinv batch, flat file is generated as below:

THEAD00000000020000000001DBMQ AUTH#xxxxxx SUPP xxxxxx 200711290000000000a360121000000001S1 20071129000000 USD000000020000-00000000000001800000-0000000000000ZZZYYYY+000000050000+000000000000 NN Y
TDETL00000000030000000001 xxxxxxxxx +000000010000-00000000000000xx0000S 00000000200000000000+00000000000000000000
TDETL00000000040000000001 xxxxxxxxx +000000020000-00000000000000xx0000Z 00000000000000000000+00000000000000000000
TDETL00000000050000000001 xxxxxxxxx +000000020000-00000000000000xx0000BP 00000000100000000000+00000000000000000000
TVATS00000000060000000001BP 00000000100000000000-00000000000000xx0000
TVATS00000000070000000001S 00000000x00000000000-00000000000000xx0000
TVATS00000000080000000001Z 00000000000000000000-00000000000000xx0000
From the above it is evident that TVAT is being updated as same cost for every line which will lead to error in Retail Invoice Matching (ReIM) while uploading the file.




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.