Incorrect Cost Getting Posted in TRAN_DATA for SIM Receiving

(Doc ID 1985841.1)

Last updated on APRIL 06, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.0.1 to 14.1 [Release 14.0 to 14.1]
Information in this document applies to any platform.


In Oracle Retail Store Inventory Management (SIM) 14.0.x, wrong Total_Cost is calculated after a transfer receipt for TRAN_DATA record with tran_code 44.  This occurs when the default currency for the sending and receiving locations is different than the default currency in the system.

Steps to Reproduce:

  1. Create a transfer for an item from warehouse and store where both warehouse and store have a currency other than the default currency in System Options.
  2. Ship the transfer. 
  3. Receive the transfer in SIM. 
  4. Check TRAN_DATA to find that TRAN_DATA.TOTAL_COST is a multiple of currency conversion rate * expected cost.





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