Search Results delete_config_exp

Overview

APPS.BOM_OE_EXPLODER_PKG is a public PL/SQL package in Oracle E-Business Suite that provides a custom Bill of Material exploder used by Order Entry. Its purpose is to build a time-independent BOM structure—classified as OPTIONAL, INCLUDED, or ALL—for a specified item and populate the results into the BOM_EXPLOSIONS table. The package is owned by APPS, belongs to the BOM product, and is classified under the ETRM taxonomy as OTHER. It is a public-scope, actively maintained, and compatible API, with the package header bearing the revision marker BOMORXPS.pls 120.0 dated 2005/05/25. The package is referenced by six other packages, reflecting its role as a shared utility for BOM explosion within the order entry context. Its business entity is tagged as BOM_BILL_OF_MATERIAL.

Key Procedures and Functions

The package exposes two documented procedures:

• BE_EXPLODER — The driving method for the explosion. It creates a time-independent OPTIONAL, INCLUDED, or ALL BOM in the BOM_EXPLOSIONS table for a given item. External applications requiring data from the explosion table must invoke this procedure before selecting directly from the table. Parameters govern organization, starting revision date, exploder type, ordering (operation sequence/item sequence), number of levels to explode, item to explode, concatenated component code, user ID, error message and error code out-buffers, and alternate BOM designator. The procedure returns a SQL error code, or 9999 if a loop is detected during explosion.
• DELETE_CONFIG_EXP — A supporting routine for managing configuration explosion data, documented alongside BE_EXPLODER as part of the published API surface. Its exact parameter list is not reproduced here.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

• BOM_EXPLOSIONS — The primary target table populated by the exploder, holding the time-independent exploded structure.
• BOM_COMPONENTS_B — Source of component definitions used to resolve the bill.
• BOM_STRUCTURES_B — Source of parent/assembly structure information.
• BOM_CONFIG_EXPLOSIONS — Referenced for configuration explosion handling, consistent with DELETE_CONFIG_EXP.
• MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_TL — Item master and translated item data used to resolve item identifiers and descriptions.
• PLITBLM — A standard EBS utility table used in this package's processing context.

Usage Notes

BOM_OE_EXPLODER_PKG is typically invoked from Order Entry flows and from custom code that requires a pre-built BOM structure in BOM_EXPLOSIONS. Because the exploder is time-independent, the caller supplies a starting revision date to anchor the explosion. Callers must invoke BE_EXPLODER first and only afterwards query BOM_EXPLOSIONS directly, ensuring the table reflects the desired explosion type and level count. Error handling should inspect the returned error code, treating 9999 as a detected loop condition that requires corrective action. The default exploder type is OPTIONAL, the default order-by is operation sequence then item sequence, and the default level limit is 20. Being a public, compatible (S) API with an active lifecycle, it is suitable for supported customizations across Oracle EBS 12.1.1 and 12.2.2.