Search Results collect_temp_data




Overview
Explore in AI Chat

Overview

BIL_DO_L1_BASE_GRP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. The "BIL" prefix identifies it as a component of the Bills of Material and Engineering module, while the "DO_L1_BASE_GRP" segment points to the Discrete Order / Level 1 base grouping utilities used when EBS assembles and stages costing and material grouping data for downstream processing. The package is classified as OTHER in the ETRM repository, meaning it is not exposed as a formal public API and is intended for internal engine use rather than direct customer invocation.

Functionally, BIL_DO_L1_BASE_GRP_PKG serves as a helper layer that populates a temporary workspace with the base group records required before higher-level grouping, explosion, or cost rollup logic executes. It is a "glue" package: it does not own business rules so much as it prepares and normalizes interim data so that subsequent logic operates against a consistent, pre-validated set of rows.

Key Procedures and Functions

The documented interface consists of a single procedure:

  • COLLECT_TEMP_DATA — Gathers and stages the interim base-group rows into the designated temporary table. In the context of its name and referenced objects, this procedure is responsible for reading the base-group source set and writing the collected results into BIL_DO_L1_BASE_GRP_TEMP, where they are available to the calling process. It is the sole entry point registered against the package in the ETRM metadata.

No parameter signatures are recorded in the metadata, so the procedure's arguments are not enumerated here. The package body also contains optimizer-statistics handling, indicated by the DBMS_STATS reference.

Tables Accessed

  • BIL_DO_L1_BASE_GRP_TEMP — A temporary, session- or process-scoped workspace table. COLLECT_TEMP_DATA writes the collected base-group records here, and consuming logic reads them back for the next stage of discrete-order grouping. The table is referenced through an APPS synonym, confirming it is resolved in the APPS schema at runtime.
  • DBMS_STATS — The Oracle-supplied statistics package, referenced to gather or manage optimizer statistics, typically against the temporary workspace so that queries against it produce stable plans during the grouping run.

Because the workspace is temporary, data volume is bounded by the scope of a single invocation rather than being persisted indefinitely.

Usage Notes

BIL_DO_L1_BASE_GRP_PKG is an internal, non-public package. The ETRM record shows it is referenced by zero other packages and that its only external dependency is the standard SYS.STANDARD package, indicating a narrow, self-contained call graph rather than a shared library used across the codebase.

  • Typical invocation — The package is expected to be called from within the Bills of Material / Discrete Order processing stack, most likely as a step inside a larger batch or concurrent processing flow rather than from a Forms-based user action.
  • Concurrent programs — Where base-group collection is required for cost or material rollups, the procedure would be invoked programmatically, not through a standalone concurrent program dedicated to this package.
  • Custom code — Because it is not a published API and is marked OTHER, direct calls from customizations are not supported. Any custom use risks breakage on patch or upgrade, and customers should instead use supported Bills of Material or costing APIs.
  • Release parity — The behavior is consistent between 12.1.1 and 12.2.2 as reflected in the ETRM metadata, though the online patching model in 12.2.x does not alter this package's internal role.

In short, BIL_DO_L1_BASE_GRP_PKG is a low-level, internal EBS package whose single procedure stages discrete-order base-group data for subsequent processing; it should be treated as engine-internal and not as integration surface.