My Oracle Support Banner

Incorrect NON_SEELABLE_QUANTITY Value in STORE_ITEM_STOCK table Post 3rd Party Stock Count Authorization (Doc ID 2736675.1)

Last updated on AUGUST 16, 2022

Applies to:

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


Universal Serial Number (UIN) which are not part of 3rd party file are marked as "missing" however STORE_ITEM_STOCK.NON_SEELABLE_QUANTITY not updated correctly.

Steps To Recreate:

  1. Select an item where as  5 UINs are in unavailable bucket and 5 UINs are in available bucket.
  2. In ITEM_UIN table, 5 UINs are in 0 status and 5 UINs were in 7 status. 
  3. Move 2 UINs from available to unavailable (sub buckets). Now user will have 3 UINs are in 0 status (In stock) and 7 are in unavailable status (7).
  4. Create a 3rd party stock count for this item and upload the file:
    • File contains 2 UINs which were in available bucket and 4 UINs which were in unavailable bucket.
  5. Post,  notice that none of the UINs are rejected and COUNT_QUANTITY and COUNTED_TOTAL both are updated as 6 in STOCK_COUNT_LINE_ITEM table.
  6. Authorize the Stock count and confirmed the variances.
  7. The TOTAL_QUANTITY in STORE_ITEM_STOCK table becomes 6 where as QUANTITY_NON_SELLABLE remains as 7.
  8. The UINs which were in unavailable buckets and not part of the 3rd party stock count file, where updated with status 8 in ITEM_UIN (i.e. missing) but the quantity corresponding to these UINs are just trimmed off from QUANTITY_TOTAL column keeping NON_SEELABLE_QUANTITY column intact. 




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.