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.
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “Item categories in oracle apps R12”
Post a Comment