Search Results edw_items_m_c




Overview
Explore in AI Chat

Overview

EDW_ITEMS_M_C is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Enterprise Data Warehouse (EDW) / Daily Business Intelligence (DBI) extraction layer for item master data. It is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner, and its header retains the original source identifier ENICITMS.pls, version 115.3 (dated 2004), consistent with legacy Oracle iStore / EDW code that remains shipped in 12.1.1 and 12.2.2 for compatibility. Its API classification is OTHER, indicating it is an internal extraction utility rather than a public or endorsed integration API.

The package acts as the "push" mechanism that copies item-related transactional and setup data from the EBS operational tables into the EDW staging tables. A package-level constant, G_VBH_CATSET_ID, is defined as 1000000006 and identifies the category set from which the item category value-based hierarchy is loaded, confirming that one category set governs the hierarchical category extracts produced by this package.

Key Procedures and Functions

Ten documented procedures constitute the API. All ten are documented as procedures; no functions are exposed.

  • Push — the sole public entry point. Unlike the remaining procedures it accepts character-based from/to dates and returns an error buffer and return code, following the standard concurrent program calling convention. It orchestrates the extraction by invoking the individual loaders below.
  • Push_EDW_ITEM_ITEM — extracts base item master records.
  • Push_EDW_ITEM_ITEMREV — extracts item revision data.
  • Push_EDW_ITEM_ITEMORG — extracts item/organization assignment data.
  • Push_EDW_ITEM_ITEMORG_CAT — extracts item/organization category assignments.
  • Push_EDW_ITEM_ITEM_CAT — extracts item-level category assignments.
  • Push_EDW_ITEM_PRDFAM — extracts product family definitions.
  • Push_EDW_ITEM_PROD_LINE — extracts product line definitions.
  • Push_EDW_ITEM_PROD_CATG — extracts product category definitions.
  • Push_EDW_ITEM_PROD_GRP — extracts product group definitions.

Every loader except Push takes native DATE parameters (p_from_date, p_to_date), reflecting the incremental high-water-mark extraction pattern typical of EDW collection programs. No parameter lists are documented for the private procedures beyond dates.

Tables Accessed

The package reads from and writes to a set of EDW staging tables exposed as APPS synonyms, plus a small number of operational reference tables.

Usage Notes

EDW_ITEMS_M_C is an internal component of the EDW / DBI collection framework and is not referenced by any other documented package. It is normally invoked through the concurrent program that calls the Push entry point, which supplies the from/to date range and the standard error buffer and return code used by the concurrent manager. The date-parameterized procedures support incremental refresh windows, so the range passed to Push determines which item changes are collected.

Because the metadata classifies this object as OTHER and the header carries the "noship" designation, the package should not be treated as a supported public API. Custom code has occasionally called the individual Push_* procedures directly for targeted extracts, but standard practice is to drive it exclusively through the supplied concurrent program. Oracle 12.2.2 continues to ship the 12.1.1 lineage of this package; behavior is materially unchanged between the two releases.