PO Total Cost Incorrectly Calculated When Using ELC Components With Different Currency Code

(Doc ID 2002248.1)

Last updated on APRIL 05, 2016

Applies to:

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

Symptoms

The Purchase Order (PO) Total Cost on stock ledger is incorrectly calculated if Estimated Landed Cost (ELC) components with a currency code different than the order or primary currency are attached.

Currently upon receipt of the PO, the final ELC is converted using the current date. However, the value used as the final ELC is the estimated expense value for the TEXP (total order expense) component ID.  This value is the sum of the estimated value for all expenses on the PO. It is calculated at the time of PO creation and recalculated if any expense changes.  Since the other expenses are not recalculated upon PO receipt, the TEXP value would not include any exchange rate fluctuations that could have affected one of the other expenses.


Steps to Reproduce:

  1. Create an order. Ensure the order currency code is not the same as the ELC currency code.
  2. Add at least 2 ELC components to the order. Add at least one other component with a currency code different from the primary and order currency code. 
    Update the TEXP component currency code to be different from the primary and order currency code. 
    Note that the value of the TEXP component is the sum of the values of the other ELC components.
  3. Receive the items on the order.
  4. Note that the total cost on the stock ledger transaction is calculated using the value of the TEXP component (converted to local currency using the current date). 
    This is incorrect, as the value of the other ELC components were not converted using the current date.

Cause

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