Item Categories in Oracle Apps

Item Categories: A category is a logical classification of items that have similar characteristics. A category set is a distinct grouping of categories. Categories and category sets group your items for various reports and programs.If you have more than one Item Category Flexfield Structure, then choose one structure first.Then enter category name and description.A category is visible in iSupplier or iProcurement Portal, if enabled here.

Item Category sets:- The categories you assign to a category set must have the same flexfield structure as the set itself. This is true even if you choose not to validate the category list.You can assign an item to multiple categories within a category set. For example, you may define a Hazard category set. In this case, an item may be assigned to both the Poison and Corrosive categories.

Default category sets:- You must assign a default category set to each of these functional areas.When you enable an item for a certain functional area, Oracle Inventory automatically assigns the item to the default category set of that functional area and the default category of that set.For example, if you set Inventory Item to Yes, then Inventory automatically assigns the item to the Inventory functional area’s default category set and default category.

 Query to get Default Category for a given Category set  in Oracle Apps:-
 
SELECT mcats.category_set_name,
       mcat.segment1 default_category,
       mcat.description cat_desc,
       mcat.category_id,
       mcats.category_set_id
  FROM mtl_category_sets mcats
      ,mtl_categories mcat
 WHERE mcat.category_id = mcats.default_category_id
     --AND mcats.category_set_name LIKE '%'