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:
- Select an item where as 5 UINs are in unavailable bucket and 5 UINs are in available bucket.
- In ITEM_UIN table, 5 UINs are in 0 status and 5 UINs were in 7 status.
- 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).
- 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.
- Post ThirdPartyStockCountImport.sh, 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.
- Authorize the Stock count and confirmed the variances.
- The TOTAL_QUANTITY in STORE_ITEM_STOCK table becomes 6 where as QUANTITY_NON_SELLABLE remains as 7.
- 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