My Oracle Support Banner

EDIDLINV Job Is Rounding Exchange Rate To 4 Decimals In The EDI Flat File For ReIM (Doc ID 2255122.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


EDIDLINV job picks up the non-merchandising invoices and writes them to a flat file for Retail Invoice Matching(ReIM). The currency exchange rate in the flat file is being rounded to 4 digits after decimal point even though Retail Merchandising System(RMS) supports up to 10 digits for currency rates.

Due to this, slight differences can be found in interfaced financial applications as same data is posting from ReIM to financials with exchange rate rounding to 4.

Steps to recreate:

  1. Create an Order.
  2. Create Shipment & Receive it.
  3. Create Obligation in EUR where exchange rate is 0.238055928 and finalize obligation.
  4. Post data to TRAN_DATA tables.
  5. Observed Values populated in tran_data are calculated with exchange rate=0.238055928 without rounding.
  6. Run edidlinv to download EDI File.
  7. Upload data into ReIM.
  8. Observe Exchange rate is rounded to 0.2381 in IM_DOC_HEAD table.


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.