What is an item category and category set?

A category is a logical classification of items that have similar characteristics. A category set is a distinct grouping scheme and consists of multiple categories. An item can belong to any number of category sets. We can assign item to one category within each category set.

Category: MTL_CATEGORIES_B

Category Set: MTL_CATEGORY_SETS_B

API to create and update category:

INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY

INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY

API to assign category to an Item:

INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY_ASSIGNMENT

INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY_ASSIGNMENT