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 DECEMBER 15, 2020

Applies to:

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

Symptoms

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 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.
  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. 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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