Need Interfaces and API's for item information

[raptors]

dear members,
I need what are the interfaces and api's for the item information in oracle. I need to do an inbound interfacing from a legacy system into oracle tables. I am giving you the sample data coming from the legacy system which is as follows :

1)
Item
Item Description
Unit of Measure
Purchasing Category (COMMODITY_CODE)
MSPEC #/REV
Item Cost
Min Quantity
Bucket Days
Flex Field Multiplier
Postprocessing (Lead time)
Requires Inspecion (Yes/No)
Requires lot control (Yes/No)
Requires lot Expiration Date (Yes/No)
Planner Code
Buyer name
Incoming Goods Date ( Flexfield)

2)
Item Number
Subinventory Name
Locator

3)
Item
Subinventory name
Locator
Lot number
Lot # - expiration date
Unit of Measure
Quantity on Hand

4)
Vendor Name
Item number
Supplier Item

could any one give the required Open interfaces and API's for the above data. i would really appreciate your responces.

thanks
sandeep

[anuprpandit]

Hello there,

I have done item conversions in implementations before as a tech consultant. You need to use standard concurrent program 'Item Import' to import the fields mentioned. Depending on the import there are multiple scenarios as below:

1>Simple item import->populate mtl_system_items_interface
2>Categroies import ->Populate mtl_system_items_interface and mtl-item_categories_interface
3>Template import->Populate mtl_system_items_interface and mtl_item_templates_inteface
4>Revisions import->Populate mtl_system_items_interface and mtl_item_revisions_interface

Run 'Item import' after populating the tables and you should see the data in master items or org items depending on the organization populated.

[azeezpasha]

Hi Anuprpandit,

Can u please forward me the coding for item conversions coz i am also working on master items conversion,
along with this if u have any conversions coding for GL,AP,AR,FA,PO,OM
modules also then please forward it to me.
Thanks in advance,

Regards,
azeezmsc@gmail.com

[san23]

sandeep, can you please guide me for the purchasing interfaces any one of three atleast, please see urgently if you can.
Thanks in advance

san

[ramya010]

Hi anuprpandit

Could you please send me Conversion scripts for Items/Categories.


thanks
ramya