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

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.