Cost-group Comingle Error and Unexpected On Hand Quantity in Material Workbench Availability Window (Commingle) (Doc ID 1925108.1)

Symptoms

When attempting to receive or transfer any quantity for a specific item into a specific locator, the following error occurs in a WMS organization.

The Cost Group ID shown in the error message is the ID of the expected Cost Group for the failing transaction. (let's say it is "Cost Group 1")
The Material Workbench Availability window is indeed showing some on hand quantity into this locator with a different Cost Group stamped (let's say it is "Cost Group 2"), but when querying the data, there is no records at all in table MTL_ONHAND_QUANTITIES_DETAIL for this item, this locator and this Cost Group "Cost Group 2".

Error
"Transaction of item with cost-group <COST_GROUP_ID> results in cost group comingle"

Expectation
User should be able to transact because there is no on hand quantity in the destination locator before performing the transaction. (or there is on hand quantity but for same Cost Group)

Steps
The issue can be replicated per the below steps: (case of Subinventory transfer)
1. Go to Inventory: (N) Transactions : Subinventory Transfer
2. Set Transaction Type to Subinventory transfer and click Transaction Lines
3. In Subinventory transfer window:
Enter the item, source subinventory and source locator
See On Hand and Available are correct at the bottom
Enter the destination subinventory and destination locator (the problematic one)
Enter the UOM and quantity
Save
Getting the reported error
4. Go to Inventory: (N) On-hand, Availability : On Hand Quantity
Query on the item
5. In Material Workbench window:
Expand the tree on the left pane until the locator node and select this node
Click Availability
See the on hand quantity is greater than zero in "On Hand" field
See "Cost Group" field is populated and it is not "Cost Group 1"

Then you may conduct a data analysis for instance as below:

6. Launch the Item diagnostic for the related item and organization. Refer to <Document:1306048.1>
Review the output file, go to section "Item Onhand Quantity".
If there is no records for the problematic locator, then the 'cost group comingle' error is unexpected.

Alternatively if any record(s) got retrieved for this locator, then run the below SQL query:

** When prompted enter the values / IDs shown in the Item diagnostic output. And for "X_cost_group_2_name", enter the Cost Group Name shown in Material Workbench Availability window.

If the above query does not retrieve any rows then the Material Workbench Availability window is showing unexpected on hand quantity and again the 'cost group comingle' error is unexpected.

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.