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)
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.
9 Responses to “Item categories in oracle apps R12”
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
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
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
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
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
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
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
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/
April 21, 2022 at 4:10 AM
I regard something truly special in this website
kizi
Post a Comment