Search Results bom_explosion_temp




Overview
Explore in AI Chat

Overview

The BOM_EXPLOSION_TEMP table is a temporary data repository within the Oracle E-Business Suite Bills of Material (BOM) module. Its primary role is to store transient data generated during the processing of indented bills of material for batch operations. This table acts as a working storage area, enabling complex multi-level bill of material explosions and implosions without permanently altering transactional data. It is fundamental to batch processes that analyze component hierarchies, such as generating cost roll-ups, material requirements planning (MRP) explosions, and where-used reports, by providing a structured, session-specific staging environment for intermediate results.

Key Information Stored

The table stores a snapshot of the exploded bill structure for a given assembly or component. While the full column list is extensive, the documented foreign key relationships highlight its core attributes. Key columns include identifiers for the bill structures being analyzed, such as TOP_BILL_SEQUENCE_ID and BILL_SEQUENCE_ID, which link to the master bill definition in BOM_STRUCTURES_B. The TOP_ITEM_ID and ORGANIZATION_ID specify the assembly and inventory organization context. The COMPONENT_SEQUENCE_ID links to specific component records in BOM_COMPONENTS_B. The TOP_ALTERNATE_DESIGNATOR allows for processing of alternate or common bill structures. Collectively, these fields enable the temporary storage of hierarchical relationships, levels, quantities, and effectivity data for all components in an exploded bill.

Common Use Cases and Queries

This table is primarily accessed by concurrent programs and batch processes rather than direct end-user queries. A common use case is the "Indented Bill of Material" report, where a process populates this table to then format and display a multi-level component hierarchy. For technical analysis or debugging, one might query the temporary explosion data for a specific session or top assembly. A sample query pattern would join to the master item and structure tables to interpret the stored IDs:

Direct manipulation of this table is atypical; processes typically call standard BOM explosion APIs which manage the population and cleanup of this temporary storage.

Related Objects

The BOM_EXPLOSION_TEMP table has defined foreign key relationships with core BOM base tables, as documented in the ETRM metadata. These relationships are critical for maintaining referential integrity and for joining to retrieve descriptive information.

  • BOM_STRUCTURES_B: Joined via TOP_BILL_SEQUENCE_ID, BILL_SEQUENCE_ID, and the composite key of (TOP_ITEM_ID, ORGANIZATION_ID, TOP_ALTERNATE_DESIGNATOR). This links the temporary explosion data to the definition of the bill of material structures for both the top-level and current-level assemblies.
  • BOM_COMPONENTS_B: Joined via COMPONENT_SEQUENCE_ID. This links the temporary records to the specific component line within a bill of material, providing access to component-specific attributes like usage quantity and effectivity dates.

This table is also conceptually related to public APIs such as BOM_EXPLOSION_PUB and concurrent programs like "Indented Bill of Material," which orchestrate its population and utilization.