# Oracle EBS BOM Interface Load Worksheet > Source: https://netray.co/tools/oracle-ebs-bom-interface-load-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Stage BOM component rows with the columns used by the Oracle BOM open interface, then export to Excel for loading. ## Category oracle ## Erp Oracle E-Business Suite ## Industry Discrete Manufacturing ## Audience - Oracle EBS consultant - Data migration lead - Engineering data steward ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### ASSEMBLY_ITEM_NUMBER **Key:** assembly **Type:** text #### ORGANIZATION_CODE **Key:** org **Type:** text #### COMPONENT_ITEM_NUMBER **Key:** component **Type:** text #### ITEM_NUM **Key:** item_num **Type:** number #### OPERATION_SEQ_NUM **Key:** op_seq **Type:** number #### COMPONENT_QUANTITY **Key:** qty **Type:** number #### Unit cost (check) **Key:** unit_cost **Type:** number **Format:** currency #### Extended cost **Key:** ext **Type:** number **Expr:** qty * unit_cost **Format:** currency #### TRANSACTION_TYPE **Key:** txn **Type:** select **Options:** - CREATE - UPDATE - DELETE #### EFFECTIVITY_DATE **Key:** eff **Type:** date **Rows:** **Assembly:** PUMP-1000 **Org:** M1 **Component:** HSG-2001 **Item num:** 10 **Op seq:** 10 **Qty:** 1 **Unit cost:** 42.5 **Txn:** CREATE **Eff:** 2026-11-01 **Assembly:** PUMP-1000 **Org:** M1 **Component:** SHF-3302 **Item num:** 20 **Op seq:** 10 **Qty:** 1 **Unit cost:** 18.75 **Txn:** CREATE **Eff:** 2026-11-01 **Assembly:** PUMP-1000 **Org:** M1 **Component:** SEAL-4410 **Item num:** 30 **Op seq:** 20 **Qty:** 2 **Unit cost:** 3.2 **Txn:** CREATE **Eff:** 2026-11-01 **Assembly:** PUMP-1000 **Org:** M1 **Component:** BLT-5105 **Item num:** 40 **Op seq:** 20 **Qty:** 8 **Unit cost:** 0.35 **Txn:** CREATE **Eff:** 2026-11-01 **Assembly:** PUMP-1000 **Org:** M1 **Component:** GSK-6120 **Item num:** 50 **Op seq:** 30 **Qty:** 1 **Unit cost:** 1.9 **Txn:** CREATE **Eff:** 2026-11-01 **Totals:** #### Total component quantity **Key:** qty **Agg:** sum **Format:** number #### Rolled-up component cost **Key:** ext **Agg:** sum **Format:** currency **Summary:** #### Average cost per component line **Key:** avg_ext **Expr:** sum_ext / count **Format:** currency **Notes:** Component columns follow BOM_INVENTORY_COMPS_INTERFACE and the header columns follow BOM_BILL_OF_MTLS_INTERFACE. The load also needs PROCESS_FLAG set to 1 and a batch or group identifier, then you run the Bill and Routing import program. Column requirements vary by release, so validate in a test instance. The unit cost column is only a local check and is not loaded. ## Content **Intro:** Loading bills of material into Oracle EBS is usually done through the BOM open interface tables. This worksheet helps you stage and sanity-check component rows in Excel before they ever reach the interface. **Sections:** #### How to use this worksheet **Body:** Replace the sample rows with your assembly, organization and component data. Choose CREATE for new components, UPDATE or DELETE for changes. Use the extended cost column and totals to spot a component with a wildly wrong quantity before load. Export to Excel, convert to a CSV or SQL loader file, and populate the interface tables through your standard conversion process. #### Header and component tables **Body:** The interface has a header table for the bill itself and a component table for each line. Rows in both are matched by assembly, organization and a transaction identifier. After loading with PROCESS_FLAG set to pending, run the Bills and Routings import program, then check the error table for rows that failed validation and fix them in the staging data. **Bullets:** - Header: BOM_BILL_OF_MTLS_INTERFACE - Components: BOM_INVENTORY_COMPS_INTERFACE - Errors: MTL_INTERFACE_ERRORS - Run the import program after the load #### Pre-load validation tips **Body:** Confirm that every assembly and component already exists as an item in the target organization with BOM Allowed enabled. Check that operation sequence numbers match the routing if one exists, and that the item sequence numbers are unique within the bill. Look for duplicate component lines and zero quantities, which are the most common reasons for rejected rows. #### Common mistakes **Body:** Loading components before the items are assigned to the organization causes mass failures. Reusing the same effectivity date for engineering and production changes can create overlapping effectivity. Finally, running an import twice without clearing earlier rows duplicates components. Always reconcile counts after load. **Cta:** If you are migrating bills of material from SyteLine, Baan or a legacy system into Oracle, we can help build and test the conversion scripts. **Faq:** #### Which tables does the Oracle BOM open interface use? **Answer:** The header goes into BOM_BILL_OF_MTLS_INTERFACE and components into BOM_INVENTORY_COMPS_INTERFACE. Revisions and routing have their own interface tables. Errors are recorded in MTL_INTERFACE_ERRORS. #### What does ACD_TYPE do? **Answer:** It marks whether a component row adds, changes or disables a component through a change order. For a plain bill load the TRANSACTION_TYPE column such as CREATE or UPDATE is the main control. #### Can I load a multi-level BOM? **Answer:** Yes. Each level is its own bill with its own assembly. Load the child assemblies first or in the same batch so that every referenced item and bill exists. #### How do I check what failed? **Answer:** Query MTL_INTERFACE_ERRORS for the transaction identifiers of your batch. Fix the staging data and reset the rows to pending before running the import again. ## Search terms oracle ebs bom interface, bom_inventory_comps_interface columns, bom_bill_of_mtls_interface, oracle bom data load template, oracle bom conversion excel, import bills and routings oracle, oracle bom open interface --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json