Please tell me what is the API we can use to load the item codes into the system in Oracle applications R12 version.
Since we have a lot of codes to be loaded into the system ,we want to use some api. Please help me out.
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
Inserting into the table mtl_system_items_interface is enough ? or need to insert into any other table also ? please advise after insert into the table mtl_system_items_interface, what are the others steps to do to get the data into main tables
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.