Search Results gcs_epb_dim_maps_pk

Overview

GCS_EPB_DIM_MAPS is a table within the GCS (Financial Consolidation Hub) product family of Oracle E-Business Suite. Its documented purpose is to hold dimension mapping definitions that translate Financial Consolidation Hub (FCH) dimensions into the Enterprise Planning and Budgeting (EPB) dimensional model. In practical terms, the table stores the correspondence between a source dimension column in the consolidation repository and a target dimension column used by EPB, allowing consolidated financial data to be aligned to the planning and budgeting dimensional structure. The product module is classified as Obsolete, and the ETRM metadata explicitly records that the object is not implemented in the reference database, meaning it may not exist in every 12.1.1 or 12.2.2 installation and should be treated as legacy or superseded functionality.

The documented physical schema for 12.1.1 lists the owner as GCS with ten columns. A heuristic Data Vault classification derived from the foreign key structure is "standalone," which suggests modeling the object as an independent reference or lookup structure rather than as a hub or link in a Data Vault sense. In other words, it is best understood as a configuration mapping table keyed by a surrogate identifier, with no documented parent-child dependencies.

Key Information Stored

The table is anchored by a documented primary key constraint, GCS_EPB_DIM_MAPS_PK, defined on the GCS_COLUMN attribute. This column acts as the surrogate row identifier and, unusually, also anchors the unique index GCS_EPB_DIM_MAPS_U1, making it the documented business-key candidate as well. The companion EPB_COLUMN stores the corresponding target dimension identifier in the EPB model, so the GCS_COLUMN/EPB_COLUMN pair expresses a single FCH-to-EPB dimensional translation rule.

The remaining documented columns support enablement and standard EBS audit and concurrency conventions:

• ENABLED_FLAG — controls whether the mapping rule is active and therefore considered during dimension translation.
• HRATE_ENABLED_FLAG — governs whether the mapping participates in the handling of consolidation or translation rates associated with the dimension.
• OBJECT_VERSION_NUMBER — supports optimistic locking for concurrent updates through the EBS framework.
• CREATION_DATE, CREATED_BY — standard creation audit attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard last-modified audit attributes, including the login context of the updating session.

Common Use Cases and Queries

Because the object is documented as obsolete and absent from the reference database, its principal use is investigative: confirming whether legacy FCH-to-EPB dimension mapping configuration exists in an environment, and auditing which mapping rules remain enabled. Typical reporting patterns include listing active mappings, checking audit recency, and joining the two dimension columns to validation or metadata views that describe dimension members in each model.

SELECT gcs_column, epb_column, enabled_flag, hrate_enabled_flag
FROM   gcs.gcs_epb_dim_maps
WHERE  enabled_flag = 'Y';

A second pattern audits configuration churn by counting changes per mapping over a period:

SELECT gcs_column, epb_column,
       last_updated_by, last_update_date
FROM   gcs.gcs_epb_dim_maps
WHERE  last_update_date >= :from_date
ORDER  BY last_update_date DESC;

Support and migration teams also use existence checks against the data dictionary prior to writing remediation scripts, since the presence of this table varies by patch level and consolidated instance history.

Related Objects

The supplied metadata records no foreign key relationships other than the primary key constraint and the unique index on GCS_COLUMN, and the Data Vault classification confirms the object is standalone. Documented related objects are therefore limited to the constraints themselves:

• GCS_EPB_DIM_MAPS_PK — the primary key constraint on GCS_COLUMN.
• GCS_EPB_DIM_MAPS_U1 — the unique index on GCS_COLUMN that serves as the business-key candidate.

No additional tables, views, or APIs are identified in the ETRM record as referencing or depending on this object. Consumers seeking the corresponding FCH or EPB dimension metadata should consult the current 12.2.2 consolidation and planning data dictionaries, as this mapping table belongs to the obsolete GCS feature set.