Search Results edw_update_attributes




Overview
Explore in AI Chat

Overview

EDW_UPDATE_ATTRIBUTES is an APPS-owned PL/SQL package classified under the OTHER API category within the Oracle E-Business Suite data warehouse infrastructure. Its role is to manage the mapping and propagation of attribute definitions (including flexfield-based attributes) that feed the Enterprise Data Warehouse (EDW) collection and staging framework. Rather than serving a specific functional module such as Payables or Order Management, this package operates as a cross-application utility that translates EBS source view structures and attribute mapping metadata into the staging layer consumed by EDW collection processes.

The package depends on a small set of foundational objects. According to the ETRM metadata, EDW_UPDATE_ATTRIBUTES references PUBLIC.UTL_FILE and SYS.STANDARD, indicating that file I/O utility routines and standard PL/SQL built-ins are used during its operation. It is referenced by two documented objects: EDW_COLLECTION_HOOK and itself (through recursive or internal invocation), confirming its position as a subordinate worker package called by the broader EDW collection orchestration layer.

Key Procedures and Functions

  • UPDATE_STG — This procedure is the primary worker routine responsible for updating staging structures associated with attribute mappings. It applies the mapping metadata to the target staging definitions so downstream EDW extraction processes receive consistent attribute assignments.
  • GETAPPSVERSION — This function returns the EBS application version context, allowing the package to apply version-appropriate logic when processing attribute mappings across Oracle EBS 12.1.1 and 12.2.2 environments.

Both routines are documented in the ETRM metadata; parameter signatures are not published and should be confirmed against the deployed package specification in each environment.

Tables Accessed

The package operates against several EDW control and mapping tables, accessed through APPS synonyms:

  • EDW_ATTRIBUTE_MAPPINGS — Stores the core attribute mapping definitions used to determine which source attributes map to staging targets.
  • EDW_FLEX_ATTRIBUTE_MAPPINGS — Holds flexfield-specific attribute mappings, supporting descriptive and key flexfield segments in the EDW model.
  • EDW_SOURCE_VIEWS — Defines the source views from which attributes are derived.
  • EDW_SV_FLEX_ASSIGNMENTS — Records which flexfields are assigned to which source views, driving flex attribute resolution.
  • UTL_FILE — Used for file-based output or logging during staging updates.
  • DBMS_SQL — Enables dynamic SQL construction, necessary because staging and attribute structures are metadata-driven.
  • PLITBLM — Provides PL/SQL index-by table management utilities supporting in-memory processing of mapping sets.

Usage Notes

EDW_UPDATE_ATTRIBUTES is not typically invoked directly by end users. It is activated through the EDW collection framework, specifically via EDW_COLLECTION_HOOK, which fires during data warehouse collection runs. Administrators and technical consultants encounter the package when configuring EDW attribute mappings, troubleshooting staging refresh failures, or extending the warehouse with custom source views and flex attribute definitions.

Because the package uses dynamic SQL and file utilities, its execution requires the appropriate directory object grants and privileges for UTL_FILE. Custom code that calls UPDATE_STG directly should account for version differences between 12.1.1 and 12.2.2, relying on GETAPPSVERSION where branching logic is required. Any modification should be validated against EDW_ATTRIBUTE_MAPPINGS and EDW_FLEX_ATTRIBUTE_MAPPINGS consistency, since malformed mappings will propagate into the staging layer and compromise downstream EDW loads.