My Oracle Support Banner

Customer Order Reserved Quantity Is Not Cleared in SIM After the Order Has Been Completed (Doc ID 2273647.1)

Last updated on MAY 27, 2020

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' .




To view full details, 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 a vibrant support community of peers and Oracle experts.