Inv Adj Unit Late Sales Wrongly Created (Doc ID 2956613.1)

Last updated on JULY 12, 2023

Applies to:

Symptoms

On : 23.1 version, Inventory Management

ACTUAL BEHAVIOR
---------------

When a POS Sale transaction containing UIN is integrated with SIOCS after a Unit stock count has been approved, the quantity of the UIN sold is not updated in the STORE_ITEM_STOCK table, UIN status remain 1 (Sold) and an Inv Adjustment is published to MFCS.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Stock Count Default Timeframe = After Store Close

1) Stock count for the store was approved at 9/6/2023 11:23:53 AM
2) SOH of 4 units with four UINs with the status 0
3) One sale has integrated for the SKU and UIN included on the count at 9/6/2023 8:18:26 PM
4) The sold unit is added from the store_item_stock table (4 units again) and an inv adj message is sent to MFCS to add the sold qty
5) On the item_uin the sold UIN continues with the status 1

So the stock count was approved at 11:23:53 AM and the sale performed at 8:18:26 PM. This is considered as a Late Sale.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the SOH is out of sync between MFCS and SIOCS.

Cause

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