Search Results gcs_utility_pkg




Overview
Explore in AI Chat

Overview

GCS_UTILITY_PKG is a shared PL/SQL utility package in the APPS schema that supports the Financial Consolidation Hub (FCH) and Enterprise Performance Foundation (EPF) components of Oracle E-Business Suite. Its role is to centralize common lookups, metadata resolution, and calendar/dimension handling logic used across the GCS (Global Consolidation System) module. Rather than duplicating logic in each calling program, the various consolidation, elimination, and dimension-mapping routines invoke this package to obtain standardized values such as organization identifiers, dimension attributes, calendar period details, and currency conversion rates. The package body is documented as VALID in the ETRM repository, and is referenced by 47 other database objects, confirming its position as a foundational dependency within the consolidation subsystem. Because it is a package body, its procedures and functions are only accessible through the corresponding package specification, and it is not referenced by any database object itself — it acts purely as a provider of reusable services.

Key Procedures and Functions

The package body exposes fourteen documented procedures and functions. They fall into several functional groups:

No parameter signatures are invented here; the documented names alone describe the intent of each routine.

Tables Accessed

The package reads primarily from the FEM (Enterprise Performance Foundation) metadata model and the GCS consolidation tables. FEM_* tables — FEM_DIMENSIONS_B, FEM_DIMENSION_GRPS_B, FEM_DIM_ATTRIBUTES_B, FEM_DIM_ATTR_VERSIONS_B, FEM_CAL_PERIODS_B, FEM_CAL_PERIODS_ATTR, FEM_ENTITIES_ATTR, FEM_ENTITIES_TL, FEM_TAB_COLUMNS_B, FEM_TAB_COLUMN_PROP, FEM_VALUE_SETS_B, FEM_TIME_GRP_TYPES_ATTR, FEM_GLOBAL_VS_COMBO_DEFS, FEM_XDIM_DIMENSIONS, FEM_APP_GRP_COL_EXCLSNS, and FEM_APP_GRP_DIM_EXCLSNS — provide dimension, entity, calendar, value set, and exclusion definitions that the utility routines resolve. GCS tables — GCS_CAL_PERIOD_MAPS, GCS_CAL_PERIOD_MAPS_GT (a global temporary table), GCS_CAL_PERIOD_MAP_DTLS, GCS_CONS_RELATIONSHIPS, GCS_CURR_TREATMENTS_B, GCS_ELIM_RULES_TL, GCS_ENTRY_HEADERS, GCS_EPB_DIM_MAPS, and GCS_SYSTEM_OPTIONS — supply consolidation calendars, relationships, currency treatment, elimination rules, entry headers, dimension maps, and system option settings. GL_DAILY_RATES is queried for currency conversion rates. Utility dependencies include APP_EXCEPTION for error raising, FND_LOG and FND_MESSAGE for logging and message resolution, and DUAL/PLITBLM/STANDARD for basic PL/SQL constructs.

Usage Notes

GCS_UTILITY_PKG is typically invoked programmatically rather than directly by an end user. It is called by the 47 dependent packages that make up the FCH and EPF consolidation flow — for example, during consolidation setup, dimension validation, calendar mapping population, entry processing, and currency translation. It may also be reached through concurrent programs and consolidation forms that perform dimension and calendar validation. Custom extensions that need consistent resolution of organization IDs, dimension-required flags, default values, or conversion rates within a consolidation context should call this package rather than reimplementing the logic, thereby preserving compatibility with Oracle-provided processing. Because the routines depend heavily on FEM and GCS metadata, they should be invoked only after the relevant consolidation model and calendar have been initialized, and callers should expect exceptions raised through APP_EXCEPTION for invalid or missing metadata.