Duplicate Item Numbers Causing APP-FND-00906 When Quering Items

Incase of any Duplicate Item then it throughs error APP-FND-00906 When Quering Item master.

Run the following steps, Check incase of any duplicate item.

SELECT organization_id, segment1, segment2, segment3, segment4, segment5,
       segment6, segment7, segment8, segment9, segment10, segment11, segment12,
       segment13, segment14, segment15, segment16, segment17, segment18, segment19, segment20,
count(*)
FROM mtl_system_items_b
GROUP BY organization_id, segment1, segment2, segment3, segment4, segment5,
         segment6, segment7, segment8, segment9, segment10, segment11, segment12,
         segment13, segment14, segment15, segment16, segment17, segment18, segment19, segment20
HAVING count(*) > 1 ;


If it returns any rows then update the duplicate items.

update mtl_system_items_b
set segment1 = segment1 || '_N/A'
where organization_id = &organization_id
and inventory_item_id = &item_id;

commit