My Oracle Support Banner

'STORE_ITEM_STOCK.QUANTITY_RESERVED' Column Mismatch Between SIM And RMS For a Transfer Created in SIM (Doc ID 2352508.1)

Last updated on JULY 29, 2020

Applies to:

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


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.