After PO receiving with UIN Item's , ITEM_UIN And STORE_ITEM_STOCK Values Are Out of Sync (Doc ID 2736673.1)

Last updated on AUGUST 16, 2022

Applies to:

Symptoms

UINs are received at wrong store created mismatch in ITEM_UIN and STORE_ITEM_STOCK table data.

Steps To Recreate:

1. Create a Purchase Order(PO) for a Serialized item in Retail Merchandising System (RMS) for store A with 10 quantities.
2. Receive the PO in Store Inventory Management (SIM) with 10 quantities where as 5 quantities in Available and 5 quantities in unavailable.
3. Verify the TOTAL_QUANTITY in STORE_ITEM_STOCK is 10 with unavailable stock : 5  and in ITEM_UIN : 5 UINs are in available status (1,2,3,4,5) and 5 UIN is in unavailable status (6,7,8,9,10).
4. Created another PO for same item in RMS for another store B with 10 quantities.
5. While receive the PO in SIM, add UIN 1,2,3,4,5 - these UINs were previously received against a PO in store A and add UIN 6,7,8,9,10 - these UINs were previously received against a PO in store A under unavailable bucket.
6. After 2nd PO at store B, the ITEM_UIN table record and STORE_ITEM_STOCK record is out of sync.
7. Results :
   • In ITEM_UIN table, UINs 1,2,3,4,5 - are ranged with store B  in Stock status.
   • In ITEM_UIN table, UINs 6,7,8,9,10 - are ranged with store A  in Unavailable status.
   • The Stock at Store A still remains the same in STORE_ITEM_STOCK table, i.e. 10 total SOH and 5 unavailable SOH.
   • The Stock at Store B in STORE_ITEM_STOCK table is 5. So, as per STORE_ITEM_STOCK table, this item should have all together 15 UINs (10 at store A and 5 at store B) , but as per ITEM_UIN table this item is having only 10 UINs, 5 at store A and 5 at store B. So, where's the "remaining" 5 UINs which are continuing stock at STORE_ITEM_STOCK against Store A but not there in ITEM_UIN table .
     
     

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.