Results for “bom_structures_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BOM_STRUCTURES_B is the master table in the Oracle E-Bills of Material module that stores bills of material (BOM) headers. Owned by the BOM schema and valid in Oracle EBS 12.1.1 and 12.2.2, it holds one row per bill of material definition, capturing the assembly item, the organization in which the bill is defined, and the alternate BOM designator. It is the parent record to which all component lines and component operations attach, and it is referenced wherever a discrete job, repetitive schedule, or engineering change needs to identify the exact BOM structure in force.

Within a heuristic Data Vault classification mined from its foreign key structure, BOM_STRUCTURES_B behaves as a hub. It carries the unique business identity of each bill of material and is referenced by a large set of dependent tables, with relatively little descriptive payload of its own. This classification is offered as a modeling suggestion rather than a documented Oracle attribute.

Key Information Stored

The surrogate primary key is BILL_SEQUENCE_ID, enforced by the BOM_STRUCTURES_B_PK constraint. A second unique index, BOM_STRUCTURES_B_UK1 (also documented as BOM_STRUCTURES_B_U1/U2), establishes the business-key candidate over ASSEMBLY_ITEM_ID, ORGANIZATION_ID, and ALTERNATE_BOM_DESIGNATOR; these three columns together identify a unique bill of material for an assembly in a given organization and alternate.

• BILL_SEQUENCE_ID — Surrogate primary key and the value propagated to every dependent component and operation row.
• ASSEMBLY_ITEM_ID — Foreign key to MTL_SYSTEM_ITEMS_B identifying the assembly being built.
• ORGANIZATION_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS; the inventory organization that owns the bill.
• ALTERNATE_BOM_DESIGNATOR — Foreign key to BOM_ALTERNATE_DESIGNATORS; distinguishes alternate bills for the same assembly.
• COMMON_BILL_SEQUENCE_ID — Self-referencing key linking a bill to its common (shared) structure across organizations.
• COMMON_ASSEMBLY_ITEM_ID and COMMON_ORGANIZATION_ID — Identify the common item and organization for the shared structure.
• PENDING_FROM_ECN — Foreign key to ENG_ENGINEERING_CHANGES; marks the ECN from which a pending change takes effect.
• STRUCTURE_TYPE_ID — Foreign key to BOM_STRUCTURE_TYPES_B, classifying the bill (for example, standard versus model).
• ASSEMBLY_TYPE — Indicates the assembly classification used in explosion logic.
• EFFECTIVITY_CONTROL and NEXT_EXPLODE_DATE — Govern date-effectivity and the next scheduled explosion of the structure.
• IS_PREFERRED — Flags the preferred structure for the assembly.
• PROJECT_ID and TASK_ID — Associate the bill with project and task context.
• SOURCE_BILL_SEQUENCE_ID — References the originating bill when a structure is copied.
• LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY — Standard audit columns for change tracking.
• Fifteen ATTRIBUTE columns plus ATTRIBUTE_CATEGORY — Flexfield extensions for customer-specific data.

Common Use Cases and Queries

The table is central to BOM explosion, where-management, engineering change control, and cost rollup. A typical query joins the header to its components to list the first-level bill for an assembly:

• SELECT b.BILL_SEQUENCE_ID, b.ASSEMBLY_ITEM_ID, c.COMPONENT_ITEM_ID, c.COMPONENT_QUANTITY FROM BOM_STRUCTURES_B b, BOM_COMPONENTS_B c WHERE b.BILL_SEQUENCE_ID = c.BILL_SEQUENCE_ID AND b.ORGANIZATION_ID = :org_id AND b.ASSEMBLY_ITEM_ID = :item_id;
• Identify all alternates for an assembly by filtering ORGANIZATION_ID and ASSEMBLY_ITEM_ID and selecting ALTERNATE_BOM_DESIGNATOR and IS_PREFERRED.
• Locate bills with pending engineering changes by joining PENDING_FROM_ECN to ENG_ENGINEERING_CHANGES.
• Resolve common structures via COMMON_BILL_SEQUENCE_ID to report a shared bill across organizations.

Explosion routines populate BOM_EXPLOSION_TEMP and BOM_SMALL_EXPL_TEMP from this table using BILL_SEQUENCE_ID and TOP_BILL_SEQUENCE_ID, so ad hoc reporting should generally align with those structures to reproduce standard explosion behavior.

Related Objects

• BOM_COMPONENTS_B — Component lines joined on BILL_SEQUENCE_ID.
• BOM_COMPONENT_OPERATIONS — Routing operations attached to the bill via BILL_SEQUENCE_ID.
• BOM_EXPLOSION_TEMP — Working table for full BOM explosion, keyed by TOP_BILL_SEQUENCE_ID and BILL_SEQUENCE_ID.
• BOM_SMALL_EXPL_TEMP — Compact explosion working table with the same key relationships.
• ENG_REVISED_ITEMS — Revised items referencing the structure through BILL_SEQUENCE_ID.
• WIP_DISCRETE_JOBS and WIP_REPETITIVE_SCHEDULES — Reference the structure through COMMON_BOM_SEQUENCE_ID.
• MTL_SYSTEM_ITEMS_B — Item master, joined on ASSEMBLY_ITEM_ID and ORGANIZATION_ID.
• BOM_ALTERNATE_DESIGNATORS — Validates ALTERNATE_BOM_DESIGNATOR within the organization.