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
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
No comments:
Post a Comment