Clicking on 'BOL' Button on a Return Creates Irregular SOH Values (Doc ID 2052056.1)

Last updated on SEPTEMBER 04, 2015

Applies to:

Oracle Retail Store Inventory Management - Version 14.1.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 return (both Return to Warehouse (RTW) and Return To Vendor (RTV)) are created, we find that:

1. SIM publishes an unnecessary message (SOStatusCre or RTVCre) when Bill of Lading (BOL) button is pressed - Note that the return is neither saved nor dispatched at this time
    a. But SIM does not publish any message, when user clicks 'Cancel' from the BOL screen
2. When an Item is added to a return and deleted, SIM does not release the return reserved quantity, thus putting the Stock on Hand (SOH) into negative
3. When an item is deleted and re-added to the same return, SIM duplicates the item and hence doubles the quantity reserved for the return - This results in SOH going into negative
4. When an item is deleted from a new return during creation and the return is cancelled, SIM does not release the return reserved quantity back to the available SOH

Steps to Recreate:

  1. Find an item and a warehouse to which it belongs
  2. Create a RTW and use the entire available SOH of the item
  3. Now click on 'BOL' button in the return create screen
  4. Note that SIM publishes a SOStatusCre (if the return is a RTW) or a RTVCre (if the return is a RTV) to RMS, which is correct, as the return has been saved when the BOL button was clicked
  5. Note that the quantity reserved values in both SIM and RMS are updated
  6. Now find that if the return is saved after Step 2 above and re-opened, the same item is duplicated and the return reserved quantity is doubled.  As a result, the SOH goes into negative.



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