SIOCS Deleting An In Progress 3rd Party Stock Count Via SOCS Doesn't Decrease OPEN_STOCK_COUNTS (Doc ID 3071120.1)

Last updated on FEBRUARY 06, 2025

Applies to:

Symptoms

On : 24.1 version, Inventory Management

ACTUAL BEHAVIOR
---------------
When deleting an In Progress stock count on the mobile device the OPEN_STOCK_COUNTS figure in STORE_ITEM_STOCK is still showing as 1 when there are no open counts.

EXPECTED BEHAVIOR
-----------------------
Once a stock count is deleted or completed and there are no more in-progress counts the OPEN_STOCK_COUNTS figure in STORE_ITEM_STOCK should show 0.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create unit stock count product group with counting method third party, hierarchy breakdown by location and auto-authorize
2. Schedule the product group for the same day and generate the stock count
3. Validate that the stock count was generated and take the snapshot
4. Delete a stock count that is in progress on the handheld
5. Validate that the STORE_ITEM_STOCK.OPEN_STOCK_COUNTS still shows as 1 against the item on the deleted stock count.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are incorrectly advised that there is an open stock count for items where there is none.

This also has a knock on affect in the processing of late sales as they are not being processed correctly unless you first set the value of open stock counts to zero.

Additional steps to see late sales issue:
---------------------
Run the same test again but instead of deleting the stock count:
4. Upload the stock count results through SIOCS FTS service
5. Validate in database the following table's data:
  --store_item_stock
  --stock_count_line_item
  --stock_count
  --stock_count_child
  --stock_count_sale
6. Validate that in the store_item_stock table you can see that the quantity _total of the item is correct, moreover we also can see that all the items have open_stock_counts , however, you don't have open stock counts for any item in that store.
7. Inject a sale in SIOCS using the REST postransaction webservice
8. Validate that the sale transaction was correctly processed
9. Validating store_item_stock table we can see that the quantity_total of the item was decremented, moreover you also can see that the open_stock_counts number is 1, however, there is no open stock counts for that item in that store
10. Validating the store item stock history we can see that no late sale transaction was generated

Cause

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