SIOCS - Rejected Sold UINs Are Being Added To The Stock (Doc ID 3007487.1)

Last updated on MARCH 05, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
The UINs are listed on the rejected items as expected and store_item_stock.QUANTITY_TOTAL is increased even though UINs status is sold or shipped.

EXPECTED BEHAVIOR
-----------------------
store_item_stock.QUANTITY_TOTAL should not be changed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create unit and amount stock count Third Party type , auto authorize set to yes and make sure you have one UIN item that has status ITEM_UIN.STATUS=1(sold) or ITEM_UIN.STATUS=5(shipped) on the group components.
2. Run generate unit & amount count job.
3. Capture the data from the store_item_stock.QUANTITY_TOTAL and ITEM_UIN.status tables.
4. Upload the third party count file and take snapshot.
5. Run the third party stock count import job.
6. verify the UIN items is on the rejected items screen on UI or in stock_count_rejected_item table.
7. Note the store_item_stock.QUANTITY_TOTAL is increased even though ITEM_UIN.status=1(sold) or 5(shipped).

Due to this issue,it is causing discrepancies on the stock count

Cause

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