Auto Inventory Adjustment Incorrectly Created From SIOCS To MFCS (Doc ID 3074448.1)

Last updated on MARCH 05, 2025

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
When we have an Auto Inventory Adjustment product group with the "Update to Zero" flag and an inventory reason which puts stock on hand in (from negative to positive), if an item has positive SOH, SIOCS updates to 0 but publishes a positive adjustment to MFCS, instead of negative.

EXPECTED BEHAVIOR
-----------------------
Expect SIOCS to publish negative adjustment.

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

1. Create a Product Group for an Auto Inventory Adjustment with:
     Inventory Reason: inbound stock movement, add stock to SOH
     Update to Zero = Yes
     Add a dept and a store and schedule for today
2. Create/find an item with positive stock and belonging to the dept in the Product Group
3. Run Auto Inventory Adjustment batch
4. Check results:
     SIOCS item stock = 0
     MFCS item stock > 0

Due to this issue, users see a mismatch in item SOH 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.