BOM Bill of Material Structure – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Description: Bill of Material Structure Report

Provides equivalent functionality to the the following standard reports:

Application: Bills of Material Source: Bill of Material Structure Report GUI (XML) Short Name: BOMRBOMSG_XML DB package: BOM_BOMRBOMS_XMLP_PKG

Report Parameters

All Organizations, Organization Hierarchy, Assembly Item, Assembly Item From, Assembly Item To, Alternate Selection, Alternate, Revision, Date, Category Set, Categories From, Categories To, Levels to Explode, Implemented Only, Display Option, Explosion Quantity, Show Substitute Components, Use Planning Percent, Bills with Loop Errors Only, Show Assembly DFF, Show Assembly Item DFF, Show Component DFF, Show Component Item DFF

Oracle EBS Tables Used

hr_all_organization_units_vl, mtl_item_categories, mtl_categories_b_kfv, bom_dependent_desc_elements, bom_explosion_temp, bom_bill_of_materials, bom_lists, mtl_system_items_vl, mtl_item_revisions_b, mfg_lookups, bom_alternate_designators, bom_ref_designators_view, bom_explosion_view, mtl_item_locations_kfv, bom_components_b, mtl_system_items_b, mtl_default_category_sets, bom_sub_components_view, q_assemblies, q_components, q_subst_comp

Report Categories

Enginatics, R12 only

FND Attached Documents, CAC Manufacturing Variance, CAC Intercompany SO Price List vs. Item Cost Comparison, CAC Last Standard Item Cost

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output BOM Bill of Material Structure - Bill of Material Structure Report 10-Oct-2025 143544.xlsx
Blitz Report™ XML Import BOM_Bill_of_Material_Structure.xml
Full SQL on Enginatics www.enginatics.com/reports/bom-bill-of-material-structure/

BOM Bill of Material Structure - Case Study & Technical Analysis

Executive Summary

The BOM Bill of Material Structure report is the blueprint of manufacturing and engineering within Oracle EBS. It provides a hierarchical representation of product structures, detailing every component, sub-assembly, and raw material required to build a finished good. This report is indispensable for production planning, cost estimation, and maintaining accurate product definitions.

Business Challenge

Manufacturing and Engineering teams often struggle with:

Solution

This report offers a flexible, multi-level explosion of the Bill of Materials. It empowers users to:

Technical Architecture

The report utilizes the Oracle BOM explosion logic to traverse the parent-child relationships defined in the database.

Key Tables & Views

| Table Name | Description | | :— | :— | | BOM_BILL_OF_MATERIALS | Stores the header information for a BOM (Assembly Item, Organization). | | BOM_INVENTORY_COMPONENTS | Stores the components (children) for each bill, including quantity and effectivity. | | MTL_SYSTEM_ITEMS_B | Defines the items (Assemblies and Components) and their attributes. | | BOM_EXPLOSION_TEMP | A temporary table often used by system reports to store the results of the BOM explosion processor. | | BOM_STRUCTURES_B | (R12) The underlying table for BOM headers, replacing some legacy views. |

Core Logic

  1. BOM Explosion: The report logic mimics the “BOM Explosion” process, starting from the top-level Assembly and recursively finding components.
  2. Effectivity Filtering: It applies Effectivity Date and Disable Date filters to ensure only currently active components are listed (unless “All” is requested).
  3. Organization Context: BOMs are organization-specific. The query ensures data is pulled for the correct manufacturing organization.
  4. Item Details: It joins to MTL_SYSTEM_ITEMS to retrieve descriptions, item statuses, and units of measure.

FAQ

Q: Can this report show “Phantom” assemblies? A: Yes, the report displays the supply type of components, allowing you to identify Phantoms, Assembly Pull, or Operation Pull items.

Q: Does it support “Alternate” BOMs? A: Yes, the Alternate Selection parameter allows you to choose specific alternates or view the primary BOM.

Q: How many levels deep can it go? A: The Levels to Explode parameter allows you to control the depth, from a single level to a full multi-level explosion.

Q: Does it show component substitutes? A: Yes, there is a parameter Show Substitute Components to include valid substitutes defined for the BOM components.

© 2026 Enginatics