Price Inquiry Shows Incorrect Cost for Items With Multiple Suppliers, Each With Different Currencies (Doc ID 2096922.1)

Last updated on MAY 27, 2016

Applies to:

Oracle Retail Price Management - Version 14.0.2 and later
Information in this document applies to any platform.

Symptoms

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.


RPM Price Inquiry shows the wrong cost when COST_CALCULATION_METHOD is set to 1 and if the item has two locations with different suppliers and different currencies each.  RPM Price Inquiry is not performing the currency conversion as it is supposed to when the inquiry is made at Zone Group / Zone levels.  The cost currency is shown in the currency of the zone, but the amount is the value in supplier currency.

Steps to Reproduce:

  1. Create Parent Item
  2. Add two suppliers to the item: one from Sweden and the other one from Finland - so that they have different currencies
    -> Supplier from Sweden: Unit Cost = 60 SEK
    -> Supplier from Finland: Unit Cost = 2 EUR
  3. Create Child SKU
  4. Range the item to Warehouse and Store belonging to same zone (EUR)
    a. Range SKU to WH and set Swedish supplier as primary
    b. Range SKU to store and Finnish supplier as primary
  5. Run future cost batches
  6. Run RPM Price Inquiry for SKU and Zone. Check that the cost is not converted from SEK to EUR.
  7. If you run Price Inquiry at SKU/Location level for WH/Store, the values are shown correctly.

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