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.