ERPstuff - Oracle EBS Community

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

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.

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

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

Hi anuprpandit

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


thanks
ramya