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:

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

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