Search Results bom_oe_exploder_pkg




Overview
Explore in AI Chat

Overview

APPS.BOM_OE_EXPLODER_PKG is a PL/SQL package body in the Oracle E-Business Suite Bill of Materials (BOM) module. Its principal business function is to support the configuration and explosion of bill of material structures specifically for Order Entry and order management contexts. Rather than serving as a purely generic BOM explosion utility, this package is tailored to the requirements of sales order processing, where configured items and model assemblies must be expanded into their constituent components so that pricing, availability, scheduling, and fulfillment activities can be performed accurately. The package name itself reflects this focus: "OE" denotes Order Entry, and "EXPLODER" denotes the recursive expansion of assemblies through the BOM hierarchy.

Key Procedures and Functions

The ETRM metadata documents two procedures or functions within this package. Parameter lists are not documented and are therefore not reproduced here.

  • BE_EXPLODER — The primary explosion routine. Its name indicates a "bill of material / order entry" exploder that walks a configured or standard assembly and returns the set of components that make up that structure. This supports the Order Entry flow by resolving the multi-level BOM into a flat or structured component list usable by downstream pricing and order line processing logic.
  • DELETE_CONFIG_EXP — A maintenance routine responsible for deleting configuration explosion records. It cleans up previously generated explosion data associated with a configuration, ensuring that stale component or explosion rows are removed when a configuration is changed or an order is revalidated.

Only these two procedures are explicitly documented in the ETRM metadata; any additional internal helpers are not listed and should not be assumed.

Tables Accessed

The package references the following tables through APPS synonyms:

  • BOM_STRUCTURES_B — Defines bill of material structure headers, providing the top-level assembly and organization context for the explosion.
  • BOM_COMPONENTS_B — Holds the component lines of each BOM, supplying the child items that make up an assembly.
  • BOM_EXPLOSIONS — The core explosion table into which exploded component rows are inserted or from which they are read.
  • BOM_CONFIG_EXPLOSIONS — Stores explosion results for configured items; DELETE_CONFIG_EXP operates against this table to purge configuration-specific rows.
  • MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_TL — Supply item master attributes and translated item descriptions for the components identified during explosion.
  • PLITBLM — A PL/SQL index-by table (associative array) declaration used internally within the package rather than a physical database table.

References to BOM_BILL_OF_MATERIALS and BOM_COMMON_DEFINITIONS are also present in the dependency information, reflecting use of standard BOM views and shared definition logic.

Usage Notes

BOM_OE_EXPLODER_PKG is an internal BOM package rather than a public, customer-facing API. It is not referenced by other database objects per the ETRM dependency report, but it is referenced by six other packages in the inventory, indicating that it is called as a subordinate utility by higher-level configuration and order entry logic. It is typically invoked during the configuration validation and order line processing sequence, where a configured model is exploded and the resulting components are staged for pricing and fulfillment. Because the package interacts with configuration explosion tables, it is not intended for direct invocation from custom code without careful consideration of concurrent configuration processing; custom integrations should generally use the documented public BOM and configuration APIs rather than this package. The package is present and valid in both Oracle EBS 12.1.1 and 12.2.2.