Customer Order Reserved Quantity Is Not Cleared in SIM After the Order Has Been Completed

(Doc ID 2273647.1)

Last updated on JUNE 12, 2017

Applies to:

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


In Oracle Retail Store Inventory Management (SIM), customer order's reserved quantity (i.e. QUANTITY_CUSTOMER_RESERVE) is not cleared in SIM STORE_ITEM_STOCK table after the order has been completed if the actual order received quantity is less than the initial order quantity.

Steps to Recreate:

1. Load the following SIMT file to SIM by running the Batch.
The initial order quantity for item '103750031' is '121' .

Note that the QUANTITY_CUSTOMER_RESERVE in the STORE_ITEM_STOCK table was updated incorrectly for ITEM_ID '103750031' to '3.3' .




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