Search Results g_conc_program_name

Overview

EDW_GL_ACCT_M_T is an Oracle E-Business Suite PL/SQL specification package owned by the APPS schema. Its naming convention, prefixed with "EDW" (Enterprise Data Warehouse) and suffixed "_M_T", identifies it as part of the Oracle Daily Business Intelligence (DBI) and Enterprise Data Warehouse materialized view generation framework used to populate the General Ledger accounting dimension. Specifically, the package builds the account dimension hierarchy that BI/EDW reporting relies upon, mapping GL account segment values into dimensional level structures stored in materialized views.

The package declares a number of global variables that reveal its runtime behaviour: g_status, g_conc_program_id, g_conc_program_name, g_execute_flag, G_COMPLETION_STATUS, g_dimension_name, g_vbh_temp_table_name, and g_global_temp_table. The presence of g_conc_program_name and g_conc_program_id confirms that the package is executed from a concurrent program context, and these globals are used to track and report the concurrent request that drives the dimension build.

Key Procedures and Functions

The package exposes two documented procedures:

• Collect — This is the primary driver procedure of the package. It accepts an error buffer, a return code buffer, and an input parameter identifying the dimension name. It orchestrates the collection and consolidation of GL account segment data, loading the values required to construct the accounting dimension. The error buffer and return code outputs follow the standard concurrent program calling convention used throughout the EDW framework for reporting completion status back to the concurrent manager.
• CREATE_DIM_LEVELS_MV — As the comment in the source ("added for bug 4124723") indicates, this procedure was introduced to create the dimension levels materialized view. It accepts a dimension number parameter and is responsible for the dynamic generation of materialized views that hold the hierarchical account dimension levels consumed by DBI reports.

Tables Accessed

The package references the following objects, generally through APPS synonyms:

• EDW_SEGMENT_CLASSES — provides the segment class/type definitions used to classify account segments.
• EDW_VBH_TEMP1 — a temporary staging table used during the hierarchy build; the t_acct_type_root_rec record type is anchored to this table's parent column.
• EDW_GL_ACCT1_M — the GL account dimension staging table.
• EDW_CONS_SET_OF_BOOKS, EDW_EQUI_SET_OF_BOOKS, EDW_SET_OF_BOOKS — set of books metadata used to determine valid ledger contexts.
• EDW_VBH_ROOTS — holds the root nodes of the value hierarchy.
• EDW_LOAD_S — load sequencing and status tracking.
• FND_ORACLE_USERID — Oracle Applications user/schema information.
• ALL_MVIEWS — queried to detect existing materialized views prior to creation.
• PL/SQL built-ins: DBMS_MVIEW, DBMS_SQL, DBMS_STATS, DUAL, and PLITBLM.

Usage Notes

EDW_GL_ACCT_M_T is not an API intended for customer extension. It is invoked internally by the EDW/DBI concurrent program framework, typically through a wrapper concurrent program that passes the dimension name into Collect. The g_conc_program_name and g_conc_program_id globals confirm that invocation occurs in a concurrent manager session. The package is referenced by zero other packages per the documented metadata, reinforcing that it functions as a top-level dimension builder rather than a shared utility. It should be treated as Oracle proprietary and not modified; customizations should be confined to the supported EDW configuration. In EBS 12.1.1 and 12.2.2, the package behaves identically, as it belongs to the technology stack layer that predates the 12.2 online patching changes.