Search Results bom_structures_b




Deep Dive into BOM_STRUCTURES_B Table in Oracle EBS 12.1.1/12.2.2

The BOM_STRUCTURES_B table is a fundamental entity in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, serving as the backbone for Bill of Materials (BOM) module functionality. It stores the core definition of item structures, enabling hierarchical relationships between assemblies and components. This table is part of the Bills of Material base tables, with "_B" suffix indicating it contains the primary transactional data, while descriptive attributes are stored in the BOM_STRUCTURES_TL (translated) table.

Key Columns and Their Significance:

  • BILL_SEQUENCE_ID: Primary key uniquely identifying each BOM structure.
  • ASSEMBLY_TYPE: Distinguishes between standard (1), model (2), option class (3), and planning (4) BOMs.
  • ASSEMBLY_ITEM_ID: Foreign key to MTL_SYSTEM_ITEMS_B representing the parent assembly.
  • ORGANIZATION_ID: Links to HR_ORGANIZATION_UNITS defining inventory organization.
  • ALTERNATE_BOM_DESIGNATOR: Allows multiple BOM versions for the same assembly.
  • COMMON_ASSEMBLY_ITEM_ID: Used for common BOMs across organizations.
  • EFFECTIVITY_DATE and DISABLE_DATE: Control active period for the BOM.
  • IMPLEMENTATION_DATE: Tracks when the BOM became active in production.

Functional Relationships:
The table maintains critical relationships with other EBS entities:
  • Joins with BOM_INVENTORY_COMPONENTS to define component items.
  • Links to BOM_REFERENCE_DESIGNATORS for component positioning data.
  • Integrates with BOM_SUBSTITUTE_COMPONENTS for alternate parts.
  • Ties to ENG_ENGINEERING_CHANGES for revision control.

Technical Implementation:
Oracle EBS implements complex business logic through database triggers and PL/SQL packages (particularly BOM and BOMR prefixes) that interact with this table. The table participates in key APIs like BOM_BO_PUB for BOM import/export and BOM_ROUTING_PUB for manufacturing integration. Indexes on ASSEMBLY_ITEM_ID, ORGANIZATION_ID, and ALTERNATE_BOM_DESIGNATOR optimize performance for common queries.

Business Process Integration:
The table supports multiple manufacturing scenarios:
  • Engineering BOMs: When ENG_ITEM_FLAG='Y' indicates design phase.
  • Configurable Products: Model/option class structures enable ATO (Assemble-to-Order) processes.
  • Global Designs: COMMON_BOM_ORGANIZATION_ID facilitates multi-org implementations.
  • Revision Control: Integration with Engineering Change Management (ECM).

Customization Considerations:
While direct modification of this table is strongly discouraged, extensions should use:
  • Descriptive flexfields (BOM_STRUCTURES_DFF)
  • Custom tables linked via BILL_SEQUENCE_ID
  • Oracle's public APIs for data manipulation

The table's design reflects Oracle's vertical integration strategy, with hooks for Product Lifecycle Management (PLM), Supply Chain Planning (ASCP), and Cost Management (CST). Proper understanding of BOM_STRUCTURES_B is essential for implementations involving complex manufacturing, product configuration, or global design management.