Search Results msd_dem_collect_bom_data




Overview
Explore in AI Chat

Overview

MSD_DEM_COLLECT_BOM_DATA is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It forms part of the MSD (Manufacturing Source Data) / DEM collection layer, which supplies bills of material and item structure information to Oracle Demand Planning and related supply chain planning collections. The package's central responsibility is to extract, transform, and stage BOM structure data from the advanced supply chain planning (MSC) tables into the demand planning staging tables used by downstream forecasting and planning engines.

The object carries a VALID status in the ETRM metadata for both 12.1.1 and 12.2.2, though it is classified as OTHER rather than as a published public API. This classification indicates that it is intended for internal invocation by the collection framework rather than as a supported integration point for customer-developed code.

Key Procedures and Functions

The documented package exposes a single procedure:

  • COLLECT_BOM_DATA — The primary collection routine. It is responsible for gathering bill of material and component-level structure records and populating the demand planning collection tables. In operation it coordinates with the history collection package (MSD_DEM_COLLECT_HISTORY_DATA) and relies on shared helper routines provided by MSD_DEM_COMMON_UTILITIES and MSD_DEM_QUERY_UTILITIES to resolve profile options, scope the extraction, and manage the staging cycle. No parameter list is published in the ETRM documentation, and the procedure should be treated as an internal worker routine rather than a directly callable interface.

Tables Accessed

The dependency metadata identifies the following tables, all reached through APPS synonyms:

  • MSC_BOMS — The advanced supply chain planning bill of materials header table. It supplies the parent-level BOM definitions that seed each collection run.
  • MSC_BOM_COMPONENTS — The planning component table supplying component item, quantity, and effectivity detail for each BOM.
  • MSC_SYSTEM_ITEMS — The planning item master, used to validate and enrich collected items with item attributes required by the demand planning model.
  • MSD_DEM_BOM_COMPONENTS — The demand planning staging table that receives the transformed BOM component rows produced by the collection.
  • PLITBLM — A public PL/SQL table-of-varchar2 type used for in-memory array processing, typical of bulk-collect style extraction loops.

Additional dependencies include FND_GLOBAL and FND_PROFILE for session and profile-option context, and SYS.STANDARD for base PL/SQL types.

Usage Notes

MSD_DEM_COLLECT_BOM_DATA is not invoked directly by Oracle Forms. It is called by the MSD demand planning collection concurrent programs, which execute the collection sequence in a defined order so that items and BOM structures are staged before history and demand data. The package is not referenced by any other database object, confirming its role as a top-level worker in the collection chain rather than a reusable library.

Because the procedure is undocumented as a public interface and is classified OTHER, customizations should not call COLLECT_BOM_DATA directly. Sites requiring modified BOM collection behavior should instead extend the supported collection programs or operate on the staging table MSD_DEM_BOM_COMPONENTS after the standard run completes. Any direct invocation risks conflicting with the collection framework's staging lifecycle and is unsupported by Oracle Support.