Edidlinv Batch Generating Wrong Flat File When RTV's With Multiple Tax Rates

(Doc ID 1945356.1)

Last updated on MARCH 13, 2018

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 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#123451 SUPP 123451 2007112900000000001360121000000001S1 20071129000000 USD000000020000-00000000000001800000-00000000000001152000+000000050000+000000000000 NN Y
TDETL00000000030000000001 100019008 +000000010000-00000000000000360000S 00000000200000000000+00000000000000000000
TDETL00000000040000000001 100019016 +000000020000-00000000000000360000Z 00000000000000000000+00000000000000000000
TDETL00000000050000000001 100019024 +000000020000-00000000000000360000BP 00000000100000000000+00000000000000000000
TVATS00000000060000000001BP 00000000100000000000-00000000000000360000
TVATS00000000070000000001S 00000000200000000000-00000000000000360000
TVATS00000000080000000001Z 00000000000000000000-00000000000000360000
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.




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