Inventory - Mass Update of Item Category
Hello group,
We are going to Oracle R12, and during my post-upgrade activities, we would like to do a Mass update on many Item Numbers to update their Item Category.
A new Category will be created inside an existing Category Set.
Below is the update Script I am about to execute. Do you see any problems in updating directly many items to this new Category?
Is there something that could cause issues in the future, or maybe not Oracle recommended?
update mtl_item_categories
set category_id = 29775
where category_set_id = 1000001005 --Stock Condition
and category_id = 5 -- REPAIRABLE
and b.segment2 like '%N'
0