Search Results edw_load_s

Overview

EDW_GL_ACCT_M_T is an Oracle E-Business Suite package body owned by the APPS schema and resident in the Enterprise Data Warehouse (EDW) layer of the EBS database. Its name denotes a GL Account dimension materialized-object build utility ("_M" indicating materialized object maintenance and "_T" the tracking or temporary variant). The package exists to construct, refresh, and manage the General Ledger account dimension levels used by the EDW star schema, drawing on the EBS Accounting Flexfield structure, segment mappings, and set-of-books configuration.

In the 12.1.1 documentation the package is classified under API classification OTHER, indicating it is not published as a public application programming interface but rather functions as an internal EDW build routine. It exposes two documented program units — COLLECT and CREATE_DIM_LEVELS_MV — and is validated as VALID in the ETRM repository. No database object in the EBS schema references this package, confirming that it operates as a terminal, self-contained utility invoked by the warehouse build process rather than as a library consumed by other PL/SQL units.

Key Procedures and Functions

The package exposes two documented program units:

• COLLECT — The primary data-collection entry point. It reads the GL account hierarchies and segment structures from the EDW source views and staging tables, applies flex segment mappings and segment class rules, and populates the intermediate dimension structures that feed the GL account dimension.
• CREATE_DIM_LEVELS_MV — Builds and refreshes the materialized views representing the account dimension levels. This unit uses DBMS_MVIEW and DBMS_SQL dynamically to create, refresh, or rebuild the underlying materialized objects, and invokes DBMS_STATS to gather optimizer statistics on the resulting structures.

No parameter lists are documented in ETRM metadata; the units are described by purpose only. No other procedures or functions are recorded for this package body.

Tables Accessed

The documented dependency list shows the package reading and writing EDW and EBS staging objects through APPS synonyms:

• EDW_SEGMENT_CLASSES, EDW_FLEX_SEG_MAPPINGS_V — supply segment classification and Accounting Flexfield value mappings used to resolve GL account segment values into dimension attributes.
• EDW_GL_ACCT1_M, EDW_GL_ACCT_M_T — the GL account dimension base and its tracking table; the package populates and reconciles these structures.
• EDW_SET_OF_BOOKS, EDW_CONS_SET_OF_BOOKS, EDW_EQUI_SET_OF_BOOKS — define the ledger and set-of-books scope for account dimension extraction.
• EDW_VBH_ROOTS, EDW_VBH_TEMP1, EDW_DIMENSIONS_MD_V — provide the value-based hierarchy roots and dimension metadata used to build account roll-ups.
• EDW_LOAD_S, EDW_LOG — the load-status and logging utilities the package calls to register execution results and trace errors.
• ALL_MVIEWS, DBMS_MVIEW, DBMS_SQL, DBMS_STATS, PLITBLM, DUAL — catalog and dynamic SQL resources for materialized view creation, refresh, and statistics gathering.
• FND_CONCURRENT, FND_GLOBAL, FND_PROFILE, FND_INSTALLATION, FND_MESSAGE, FND_ORACLE_USERID, V$INSTANCE — foundation-layer context: concurrent request identity, session context, installation mode, message lookup, and instance detection.

Usage Notes

EDW_GL_ACCT_M_T is invoked as part of the EDW dimension build cycle, typically through the EDW load orchestration (the EDW_LOAD_S dependency indicates the warehouse load driver calls this package). It is not exposed through a standard EBS form and should not be called from custom application code. Execution is normally scheduled as a concurrent program or invoked within the EDW refresh job stream, dependent on the existence and validity of the Accounting Flexfield configuration and set-of-books definitions. Because it creates and refreshes materialized views, invocation requires elevated privileges within APPS and should be run during a maintenance window. Results and errors are recorded through EDW_LOG for diagnosability.