Item Interface Program

ITEM CONVERSION: imports item and his item attributes along with revision details
I wrote a custom program that extracts item information from the legacy system to a flat file and used SQL* Loader to upload information into a temporary table.
Then I wrote pl sql program to insert item details into the interface tables MTL_SYSTEM_ITEM_INTERFACE table, and revision details MTL_ITEMS_REVISIONS_INTERFACE table.
After loading the items into interface tables, I run the Item Interface to import the data. The Item Interface assigns defaults, validates data e, and then imports the new items

INTERFACE TABLES:
MTL_SYSTEM_ITEMS_INTERFACE, MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE(used internally by item interface)

BASE TABLES:
MTL_SYSTEM_ITEMS_B (Segment 1 stores Model # of Item) MTL_ITEM_ATTRIBUTES, MTL_ITEM_CATEGORIES, MTL_ITEM_LOCATIONS, MTL_ITEM_REVISIONS, MTL_ITEM_STATUS

INSERT INTO mtl_system_items_interface (segment1, description, organization_id,transaction_type, set_process_id, inventory_item_id)
VALUES('W800ii', 'sony_erricson',204,'CREATE',10001601, 343);

Run Import items program with parameters
all organizations,
validate items,
process items
Delete processed rows,
process set

Bom Interface

BOM INTERFACE - import Bills of Material including revision, bill comments, components, substitute components, and reference designator information. The Bills of Material Business Object Interface can process all types of bills, including model, option class, planning, standard and product family. The Bills of Material Object Interface insure that your imported bills of material contain the same detail as those you enter manually in the Define Bill of Material form.

I wrote a custom program that extracts item information from the legacy system to a flat file and used SQL* Loader to upload information into a temporary table
Then I wrote pl sql program to insert item details into the interface tables BOM_BILL_OF_MATERIALS_INTERFACE table.
After loading the items into interface tables, I run the Item Interface to import the data. The Item Interface assigns defaults, validates data e, and then imports the new items

BASE TABLES:
BOM_BILL_OF_MATERIALS – stores information about the bill of material header item or the assembly item
(BILL_SEQUENCE_ID)
MTL_ITEM_REVISIONS – stores information about bill of materials revisions
BOM_INVENTORY_COMPONENTS – stores information about the un implemented single level BOM components
BOM_SUBTITUTE_COMPONENTS – stores information about the un implemented BOM component reference designators
BOM_REFERENCE_DESIGNATORS – stores information about the un implemented substitute components associated with a BOM components
BOM_RESOURCES stores information about resources, overheads, material overheads, and material sub–elements. COST_ELEMENT_ID determines the type of the resource.
BOM_OPERATIONAL_ROUTINGS stores information about manufacturing and engineering routings.