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.

9 Responses to “Item categories in oracle apps R12”

tike mik said...
January 12, 2021 at 7:24 AM

I’d always want to be update on new articles on this web site , saved to favorites ! . Portrait Pro Studio Crack


Malik.amir said...
July 26, 2021 at 10:13 AM

I have been checking this blog constantly and I am very impressed! Veryusefulinformation, especially the lastpart 🙂This information is very important to me. Ihave been searching for this information for a long time. Thank you and good luck.
portraitpro crack



malikamir said...
September 29, 2021 at 6:09 PM

Thanks for sharing this wonderful article with us. Your article is really good. If you are looking for the best assistance with assignments, please visit our website Cheapassignmenthelp.co.uk. For more information, please see the links below.
rarsoftpc.com


Zaki Saanvi said...
December 2, 2021 at 9:18 AM

Howdy! This post couldn’t be written any better! Reading this post reminds me of my good old room mate! He always kept chatting about this.
I will forward this post to him. Pretty sure he will have a good read.
Thanks for sharing!
nod32 crack
quicktime serial
filmora 9 crack download without watermark
bluebeam revu product key
reflector license key mac
Crack Like


Unknown said...
December 26, 2021 at 9:25 AM

Thanks for sharing this wonderful article with us. Your article is really good. If you are looking for the best assistance with assignments, please visit our website.
4k video downloader crack
nordvpn crack
movavi video converter crack
imazing crack
wondershare filmora crack
crackaynthing


Crackkick.com said...
January 9, 2022 at 11:01 AM

Thanks for sharing such great information, I highly appreciate your hard-working skills which are quite beneficial for me
Tuxler Crack
Ultraviewer Crack
Vidjuice Unitube Crack
Zebra Designer Crack
Letsview Crack
Mathtype Crack
Sourceguardian Crack
Combo Cleaner Crack
WinRAR Crack


Unknown said...
February 3, 2022 at 5:39 AM

Thanks for sharing such great information, I highly appreciate your hard-working skills which are quite beneficial for me.


wincatalog crack
goodsync crack
sandboxie crack
ultraedit crack
manycam pro crack
crackaynthing


Charli Monster said...
March 14, 2022 at 11:26 PM

Everything is very open with a very clear description of the issues. It is really informative. This article is extremely helpful. Thanks for sharing. You Can free download it:https://freesoftwareapps.com/corel-draw-x6-serial-key-crack/


Anonymous said...
April 21, 2022 at 4:10 AM

I regard something truly special in this website
kizi


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.