Why Is the Change in Unit Cost of an Item During DSD Receiving Not Reflected in RK_ORDER_ITM Table? (Doc ID 1390122.1)

Last updated on FEBRUARY 05, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 12 and later
Information in this document applies to any platform.
Checked for relevance Aug 2013

Goal

For a direct delivery against a newly created Purchase Order (PO) in Store Inventory Management (SIM), when the unit cost is modified, it is getting updated in the RK_SHIPMENT_ITEM -  but not in the RK_ORDER_ITM table.  Why the discrepancy?


Steps to Reproduce
:

  1. Navigate to Shipping/Receiving => Create New.
  2. Select Supplier and for the Purchase Order select New.
  3. Add an Item.
  4. Edit the unit cost of the item (say, from $10.00 to $11.00)
  5. Enter the quantity and confirm the delivery.
  6. Notice that the unit cost of the item in RK_SHIPMENT_ITEM  is updated to $11, but RK_ORDER_ITEM.UNIT_COST still shows $10.
This issue also holds true for the case in which the PO comes from the Retail Merchandising System (RMS) application and the unit cost is modified on direct delivery in SIM.

 
As per the data model, RK_ORDER_ITEM.UNIT_COST should hold the unit cost of the item for the specific purchase order.  So, it is expected to have the updated unit cost.

Solution

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