Item Has 2 Category Assignments On Organization Level

Item Has 2 Category Assignments On Organization Level

ACTUAL BEHAVIOR
---------------
Item has 2 category assignments on organization level while it is master controlled.
The assignment has the same category set while "Allow multiple item category assignments" is disabled.
On master level there is only one category. It only exists on 2 organization levels.

EXPECTED BEHAVIOR
-----------------------
Get a single category for the item.


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

1. Inventory > Items > Master Item > Search item (example) AB54888 > Tools > Categories > Here you see only 1 assignement of category (example) "PRODUCT"
2. Inventory > Items > Master Item > Search item (example) AB54888 > Tools > Organization assignement > select organization > click org attributes > Tools > Categories > Here you see only 2 assignement of category (for example) "PRODUCT"

Test the Result 

You can use a query like the following:

• SELECT * from FROM mtl_item_categories WHERE inventory_item_id = &inv_item_id;