Need Interfaces and API's for item information

Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
Post Reply
raptors
Posts: 7
Joined: Tue Aug 29, 2006 2:42 am
Location: USA

Need Interfaces and API's for item information

Post by 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
Posts: 4
Joined: Tue Nov 21, 2006 1:23 am
Location: India

Post by 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
Posts: 26
Joined: Fri Nov 10, 2006 3:15 am
Location: India

Post by 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
Posts: 2
Joined: Wed Feb 21, 2007 1:06 am
Location: India

Post by 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
Posts: 1
Joined: Fri Apr 01, 2011 6:14 pm
Location: USA

Post by ramya010 »

Hi anuprpandit

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


thanks
ramya
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests