Search Results gcs_historical_rates

Overview

The GCS_HISTORICAL_RATES table is a core data structure within the Oracle E-Business Suite (EBS) module GCS - Financial Consolidation Hub. This module, now designated as obsolete in the provided ETRM metadata for versions 12.1.1 and 12.2.2, was responsible for the financial consolidation and reporting process across multiple entities and currencies. The table's primary role was to store historical foreign exchange rates used specifically for translating financial data during the consolidation cycle. These rates are critical for ensuring accurate currency conversion of balance sheet and income statement items according to the accounting standards (e.g., FASB 52, IAS 21) governing the consolidation.

Key Information Stored

While the specific column list is not detailed in the provided excerpt, the documented foreign key relationships define its essential structure. The table centrally stores the conversion rate between a specific currency pair for a given period and consolidation hierarchy. Key inferred columns include HIERARCHY_ID, which links to a specific consolidation hierarchy (GCS_HIERARCHIES_B); FROM_CURRENCY and TO_CURRENCY, which define the currency pair (both referencing FND_CURRENCIES); and a RATE column to store the actual conversion factor. Additional columns would typically include effective date ranges (e.g., START_DATE, END_DATE), rate type identifiers, and standard Who columns (CREATION_DATE, LAST_UPDATE_DATE, etc.) for auditing.

Common Use Cases and Queries

The primary use case is the automated retrieval of appropriate historical rates during the translation process of a consolidation. A consolidation engine would query this table to find the correct rate for a given currency pair, hierarchy, and accounting period. A typical query pattern would be:

• Retrieving a Rate for Translation: SELECT rate FROM gcs_historical_rates WHERE hierarchy_id = :p_hierarchy_id AND from_currency = :p_ent_currency AND to_currency = :p_cons_currency AND :p_accounting_date BETWEEN start_date AND end_date;
• Auditing Rate History: Generating reports to review the rates applied in past consolidations for a specific currency, often joining with FND_CURRENCIES for currency names.

Related Objects

The table maintains documented foreign key relationships with three other EBS objects, ensuring referential integrity for its key dimensions:

• GCS_HIERARCHIES_B: Joined via GCS_HISTORICAL_RATES.HIERARCHY_ID = GCS_HIERARCHIES_B.HIERARCHY_ID. This links the rate to a specific consolidation hierarchy.
• FND_CURRENCIES (From Currency): Joined via GCS_HISTORICAL_RATES.FROM_CURRENCY = FND_CURRENCIES.CURRENCY_CODE. This validates the source currency of the rate.
• FND_CURRENCIES (To Currency): Joined via GCS_HISTORICAL_RATES.TO_CURRENCY = FND_CURRENCIES.CURRENCY_CODE. This validates the target currency of the rate.

Given the module's obsolete status, this table is likely referenced by other GCS consolidation processing tables and the core consolidation engine programs, though those specific dependencies are not listed in the provided metadata.