This content has been marked as final. Show 5 replies
I assume you are talking about item numbers.
For a "lot of" item codes, I suggest using the Item open interface. The main table is mtl_system_items_interface and then launch a process called "Item Import".
See http://docs.oracle.com/cd/A60725_05/html/comnls/us/inv/imprtifc.htm for details.
See http://kutuboracle.blogspot.com/2008/08/item-upload-thru-itenm-interface.html for sample code
Depends on what other data you are trying to load.
Mtl_system_items_interface is the main table.
If you need to load item revisions, you use mtl_item_revisions_interface.
For categories, load mtl_item_categories_interface etc.
This is one of the most frequently used interfaces in EBS. See http://kutuboracle.blogspot.com/2008/08/item-upload-thru-itenm-interface.html for detailed step by step instructions.