'STORE_ITEM_STOCK.QUANTITY_RESERVED' Column Mismatch Between SIM And RMS For a Transfer Created in SIM

(Doc ID 2352508.1)

Last updated on JANUARY 29, 2018

Applies to:

Oracle Retail Store Inventory Management - Version 15.0 and laterInformation in this document applies to any platform.

Goal

When a Transfer Request is created in Retail Store Inventory Management (RSIM) the status of the transfer in SIM is '2' (Requested) and the STORE_ITEM_STOCK.QUANTITY_RESERVED is not updated for this quantity.But a SOStatusCre message is sent to Retail Merchandising System (RMS) and this is creating a transfer in RMS with status 'A' resulting in updating TSF_RESERVED_QTY column in RMS.

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