Loading

Thursday, June 3, 2010

Item categories in oracle apps R12

What is the use of Item Categories?
Ø      Use categories and category sets to group your items for various reports and programs.
Ø      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.
Ø      Some application modules, Inventory, for example require that all items are assigned to a category.
Ø      The user specifies a default category for this purpose in each of these modules.

How to  SETUP?



What are the Tables Involved?

Table
Info
fnd_id_flex_structures
Holds the Flexifeild structure
mtl_categories_b
Category data
mtl_categories_tl
mtl_category_sets_b
Category Sets Data
mtl_category_set_valid_cats
Assignment of Category to Category Sets
mtl_system_items
Holds Item Information
mtl_item_categories
Item - Category Assignment
mtl_item_categories_interface
Open interface table for importing Item Category Assignment
mtl_interface_errors
Interface Error Table

Is there any public API’s available?

 Below are the some of the important API’s that can be used,

API
LINK
INV_ITEM_CATEGORY_PUB.DELETE_CATEGORY
INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY
INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY
INV_ITEM_CATEGORY_PUB.CREATE_VALID_CATEGORY
INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY_ASSIGNMENT
INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY_ASSIGNMENT
INV_ITEM_CATEGORY_PUB.DELETE_CATEGORY_ASSIGNMENT

Is there any Open interface program available to import item category assignment?

In order to reduce the size of the post, I moved this content to a separate post.

0 Responses to “Item categories in oracle apps R12”

Post a Comment