Pending Inventory Adjustment Records Are Not Updated While Performing an RTV or RTW Using Unavailable Inventory

(Doc ID 1136023.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 13.1 to [Release 13.1]
Information in this document applies to any platform.
Checked for relevance on 14-Aug-2013


Pending inventory adjustment records are not updated when a Return to Vendor (RTV) or a Return to Warehouse (RTW) is performed using unavailable inventory in Store Inventory Management (SIM).

Steps to Reproduce:

  1. Query SIM database table RK_STORE_ITEM_SOH table and note down the item id, and store id.
  2. Ensure that the item has positive value for RK_STORE_ITEM_SOH.TOTAL_QUANTITY column (for example 10)
  3. Log into SIM PC client and create an inventory adjustment with reason as "Damaged - Hold" for a quantity of 5
  4. Query RK_STORE_ITEM_SOH and note the value of RK_STORE_ITEM_SOH.TOTAL_QUANTITY (as 10)  and RK_STORE_ITEM_SOH.ADJUST_UNAVAIL_QTY (set to 5)
  5. In SIM, Navigate to 'Main Menu' > 'Shipping/Receiving' > 'Returns'
  6. Create a RTV for the same item with quantity of 6.
  7. Click 'Yes' when prompted with "Would you like to use the unavailable inventory in the return" message
  8. Dispatch the RTV
  9. Query RK_STORE_ITEM_SOH and note the RK_STORE_ITEM_SOH.TOTAL_QUANTITY value change to 4 and RK_STORE_ITEM_SOH.ADJUST_UNAVAIL_QTY value changed to 0
  10. In SIM, navigate to 'Main Menu' -> 'Inv Mgmt' -> 'Inventory Adjustment' and open the Inventory Adjustment that is created in step 2 (the status in 'Pending')
  11. Enter quantity as 5 and choose the reason as 'Returns'
  12. Click on 'Done'
  13. Query RK_STORE_ITEM_SOH and notice, the value of RK_STORE_ITEM_SOH.TOTAL_QUANTITY set to 4 and RK_STORE_ITEM_SOH.ADJUST_UNAVAIL_QTY set to -5
  14. Look up the item in Item Look up in SIM and notice the following:


Total stock on hand: 4
Total Available: 9
Unavailable: -5

The same issue can be observed for an RTW


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