Inventory Management - EBS (MOSC)

MOSC Banner

Inventory - Mass Update of Item Category

edited Mar 8, 2013 1:09AM in Inventory Management - EBS (MOSC) 1 commentAnswered
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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center