My Oracle Support Banner

TRAN_DATA.TOTAL_COST_EXCL_ELC Is Calculated Using Posted Date Exchange Rate Instead Of Transaction Date Exchange Rate (Doc ID 2664354.1)

Last updated on AUGUST 16, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

For Import Order when Receiver Unit Adjustment (RUA) is performed TOTAL_COST_EXCL_ELC in TRAN_DATA is calculated based on the posted exchange rate.

Steps To Recreate:

  1. Create an Import Purchase Order(PO).
  2. Receive it fully.
  3. Perform on RUA on the date where the effective currency rate is different than the one used when the original receipt happened.

Sample Data:

PO Number XXX
Item A
Transaction Date 31-JAN-2020
Posted Date 02-FEB-2020
Exchange rate on Transaction date (31-Jan-2020) 106.00
Exchange rate on Posted date (2nd-FEB-2020) 104.00
Total units 316
Unit cost in USD 2.12
TRAN_DATA.TOTAL_COST 16*2.12*106 = 71012
TRAN_DATA.TOTAL_COST_EXCL_ELC 316*2.12*104 = 69672

 

Cause

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
Symptoms
Cause
Solution
References


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