'Severe System Error' Occurs When a Store Order Is Created for More Quantity Than Available at Warehouse (Doc ID 1998675.1)

Last updated on OCTOBER 12, 2015

Applies to:

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


The issue described in this document is known to Oracle, and a fix is already scheduled for future release. This article will be updated as official patch becomes available.

In Store Inventory Management (SIM), when a store order is created for a warehouse, if the quantity specified for the store order is greater than the available quantity at the warehouse, a "Severe system error" is thrown.

Steps to recreate:

1. Find an item that is ranged to a store in Retail Merchandising System (RMS) and SIM
2. Ensure that the item is also ranged to a virtual warehouse in RMS, whose physical warehouse exists in SIM - Note down the physical warehouse ID
3. Query RMS database table ITEM_LOC_SOH with the item ID and virtual warehouse ID and note down the available Stock On Hand (SOH)
4. In SIM, log into the store and create a Store Order from that store, for the item chosen, to the physical warehouse
5. Add the item and enter the requested quantity as more than what is available in Step 3 for SOH
6. Click on 'Approve' and note the "Severe system error" pop up

The following error is shown in the message 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 hundreds of Community platforms