WIP Completion Via Mobile Device Creates A Cost Group Comingle Error (Doc ID 2612057.1)

Last updated on NOVEMBER 14, 2023

Applies to:

Symptoms

When users are attempting to complete assembly transaction from MSCA app,they are unable to complete due to cost group comingle and the following error occurs:

ERROR
-----------------------
TXN Failed. Transaction of item with cost group xxx results in cost-group comingle.

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

1.Create a non-standard project job with Assembly pull negative requirement for common supply locator
2.Perform job release and component pick release
4. See task allocated to employee via Warehouse control board
5. See LPN dropped successfully and consumed directly to the job
6. Try to Complete assembly transaction and When user tries to save the transaction and system throws above mentioned error.
7. Try to repeat same with a second identical job and the co-mingle error occurs;  


Technically, a WIP Completion backflush negatively issues the component into the common locator, however sql shows that on-hand mtl_onhand_quantities_detail record at the common locator has project_id  and cost_group_id set to correspond to the job's
project i.e. there is a mismatch between the locator and the on-hand project info (on-hand incorrect).
Try to repeat with a second identical job and the co-mingle error occurs;  
Now remove the incorrect on-hand and the next completion is ok but moqd project_id and cost_group_id are incorrectly set)
Perform multiple non-standard project jobs with Assembly pull negative requirement for a project supply locator can be completed without a problem (as the locator and  on-hand project info matches).


Workaround
-----------------------
When this stock is removed from the location, leaving the location empty ,users are able to complete the job without issues.

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.