Search Results gl_fixed_conv_rates_pk




Overview
Explore in AI Chat

Overview

GL.GL_FIXED_CONV_RATES is a General Ledger reference table that stores fixed conversion rates applied when a national currency is replaced — for example, at the introduction of the Euro or similar redenominations. Rather than relying on the daily or periodic rates held in GL_DAILY_RATES, Oracle EBS uses this table to translate amounts between a superseded currency and its replacement at a permanently fixed, legislated ratio. The table is owned by the GL schema and is classified as VALID in ETRM 12.2.2, and it exists in both 12.1.1 and 12.2.2 environments under the same structure.

Under a heuristic Data Vault classification derived from its foreign-key topology, the table is best modeled as a link. It connects two currency entities (OLD_CURRENCY and REPLACEMENT_CURRENCY) with an associated descriptive measure (FIXED_CONVERSION_RATE) and effectivity attributes. This is only a modeling suggestion; within EBS the object functions as a conventional, multi-tenant lookup table.

Key Information Stored

The documented physical schema contains nine columns. The most significant are:

  • OLD_CURRENCY — the currency being replaced. This is the primary key column of GL_FIXED_CONV_RATES_PK and also the single-column business-key candidate carried by unique index GL_FIXED_CONV_RATES_U1. Because the primary key is the business key, the table is effectively one row per superseded currency.
  • REPLACEMENT_CURRENCY — the successor currency to which amounts are converted (for example, a legacy national currency replaced by the Euro).
  • FIXED_CONVERSION_RATE — the immutable, legally mandated multiplier used to translate from the old currency to the replacement.
  • EFFECTIVE_START_DATE — the date from which the fixed rate becomes applicable.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS WHO-column audit trail identifying when, by whom, and through which login session the record was last changed.
  • CREATION_DATE, CREATED_BY — the creation audit pair recording when and by whom the row was inserted.

There is no separately generated surrogate sequence column documented; the surrogate and business keys coincide on OLD_CURRENCY. Both currency columns are constrained by foreign keys to FND_CURRENCIES, guaranteeing that only enabled, defined ISO currencies can participate.

Common Use Cases and Queries

Typical scenarios include validating redenomination setup, reconciling converted balances after a currency change, and auditing which currencies have fixed rates defined. A basic lookup joining both currency codes to their descriptions follows:

  • SELECT fcr.old_currency, oc.name old_name, fcr.replacement_currency, rc.name rep_name, fcr.fixed_conversion_rate, fcr.effective_start_date FROM gl_fixed_conv_rates fcr, fnd_currencies oc, fnd_currencies rc WHERE fcr.old_currency = oc.currency_code AND fcr.replacement_currency = rc.currency_code;
  • Rate retrieval for a specific superseded currency: SELECT fixed_conversion_rate FROM gl_fixed_conv_rates WHERE old_currency = :p_currency AND effective_start_date <= :p_date;
  • Completeness audit: compare all replacement currencies against the set defined in FND_CURRENCIES to detect missing or orphaned rate definitions.
  • Change tracking via LAST_UPDATE_DATE and LAST_UPDATED_BY to review who amended a legislated rate and when.

Related Objects

  • FND_CURRENCIES — referenced twice: GL_FIXED_CONV_RATES.OLD_CURRENCY → FND_CURRENCIES and GL_FIXED_CONV_RATES.REPLACEMENT_CURRENCY → FND_CURRENCIES.
  • GL_DAILY_RATES — the general daily/periodic rate table used in normal foreign-currency translation, complementary to this fixed-rate table.
  • GL_CURRENCY_DAILY_RATES and associated GL currency-rate reporting views.
  • FND_CURRENCIES_B / FND_CURRENCIES_TL — the underlying base and translation tables behind FND_CURRENCIES, useful when joining currency names in multilingual reports.
  • GL_DAILY_CONVERSION_TYPES — defines conversion-rate types referenced by GL rate processing.
  • Key indexes to be aware of for tuning: GL_FIXED_CONV_RATES_PK and GL_FIXED_CONV_RATES_U1, both on OLD_CURRENCY.