Search Results bom_small_expl_temp




Overview
Explore in AI Chat

Overview

The BOM_SMALL_EXPL_TEMP table is a temporary data structure within the Oracle E-Business Suite Bills of Material (BOM) module. Its primary function is to serve as a transient repository for data generated during online, user-driven indented bill of material explosion processes. Unlike permanent tables that store master data, this table holds session-specific or request-specific data for the duration of an online operation, such as viewing an indented BOM structure from a form. It facilitates the efficient assembly and presentation of hierarchical component relationships without persisting the intermediate results, thereby optimizing performance for real-time user interactions in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to capture the hierarchical and relational data necessary for an indented BOM explosion. While the full column list is not detailed in the provided metadata, the documented foreign key relationships reveal its core entities. Key stored information includes identifiers for the top-level assembly being exploded (TOP_BILL_SEQUENCE_ID, TOP_ITEM_ID, TOP_ALTERNATE_DESIGNATOR) and the specific organization (ORGANIZATION_ID). It also stores references to the component structures (BILL_SEQUENCE_ID) and the individual component items (COMPONENT_SEQUENCE_ID) within the explosion hierarchy. This allows the system to temporarily map the complete parent-child relationship tree from a top-level assembly down to its lowest-level components.

Common Use Cases and Queries

The primary use case is supporting the "Indented Bill of Material" online inquiry within the BOM module. When a user requests an indented view of an assembly, the application populates this table with the explosion data for that session. Common queries against this table are typically embedded within Oracle's standard forms and reports. A sample analytical query pattern might involve joining to master tables to create a readable indented report from the temporary data:

  • SELECT bs.segment1 top_assembly, comps.segment1 component, bset.level_num FROM bom_small_expl_temp bset JOIN bom_structures_b bs ON bset.top_bill_sequence_id = bs.bill_sequence_id JOIN bom_components_b comps ON bset.component_sequence_id = comps.component_sequence_id WHERE bset.request_id = :p_request_id ORDER BY bset.explosion_sequence;

Direct manual querying is often performed for debugging or to analyze the output of a specific concurrent request that utilizes this temporary table.

Related Objects

BOM_SMALL_EXPL_TEMP has defined foreign key relationships with core BOM master tables, ensuring data integrity for the temporary explosion. The documented relationships are:

  • BOM_STRUCTURES_B: The table references this master bill definition table three times.
    • Via BOM_SMALL_EXPL_TEMP.TOP_BILL_SEQUENCE_ID
    • Via BOM_SMALL_EXPL_TEMP.BILL_SEQUENCE_ID
    • Via BOM_SMALL_EXPL_TEMP.TOP_ITEM_ID
  • BOM_COMPONENTS_B: The table references this component definition table.
    • Via BOM_SMALL_EXPL_TEMP.COMPONENT_SEQUENCE_ID

These relationships confirm that the temporary explosion data is anchored to valid, permanent definitions of assemblies, alternate designs, and components.