Cost-group Comingle Error and Unexpected On Hand Quantity in Material Workbench Availability Window (Commingle)
(Doc ID 1925108.1)
Last updated on OCTOBER 19, 2017
Applies to:Oracle Warehouse Management - Version 18.104.22.168 and later
Oracle Inventory Management - Version 22.214.171.124 and later
Information in this document applies to any platform.
*** Checked for relevance on 04-Mar-2016 ***
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".
"Transaction of item with cost-group <COST_GROUP_ID> results in cost group comingle"
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)
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
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
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.
where moqd.organization_id = &X_organization_id
and moqd.inventory_item_id = &X_inventory_item_id
and moqd.subinventory_code = '&X_subinventory_name'
and moqd.locator_id = &X_locator_id
and moqd.cost_group_id in (
from cst_cost_groups ccg
where ccg.cost_group = '&X_cost_group_2_name' -- enter the Cost Group Name for "Cost Group 2"
ccg.organization_id is null
or ccg.organization_id = moqd.organization_id
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document