Search Results gl_daily_rates

Overview

The GL_DAILY_RATES table is a core data structure within the Oracle E-Business Suite General Ledger (GL) module. Its primary role is to store daily conversion rates required for translating foreign currency transactions into the functional or reporting currency of an enterprise. This table is fundamental to the system's multi-currency capabilities, enabling accurate financial reporting, journal entry conversion, and revaluation processes. The integrity of the data in GL_DAILY_RATES is critical for ensuring that all currency conversions performed across Oracle EBS 12.1.1 and 12.2.2 are consistent and auditable.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each exchange rate record. The key columns are FROM_CURRENCY (the source transaction currency), TO_CURRENCY (the target conversion currency), CONVERSION_DATE (the effective date of the rate), and CONVERSION_TYPE (the category of rate, such as 'Corporate', 'Spot', or a user-defined type). Each record stores the corresponding conversion rate, allowing the system to calculate the equivalent amount in the target currency. The table maintains foreign key relationships to FND_CURRENCIES for currency validation and to GL_DAILY_CONVERSION_TYPES to ensure the conversion type is defined within the application.

Common Use Cases and Queries

The primary use case is the automated conversion of journal entries during posting. The system queries GL_DAILY_RATES using the journal's currency, date, and assigned conversion type to find the applicable rate. It is also central to the period-end revaluation process. Common reporting queries include verifying rates for a specific period or currency pair. A typical validation query is:

• SELECT from_currency, to_currency, conversion_date, conversion_type, conversion_rate FROM gl_daily_rates WHERE conversion_date BETWEEN :p_start_date AND :p_end_date AND from_currency = :p_currency;

Administrators often use this table to diagnose conversion errors, audit rate entries, and ensure all required rates are populated before critical financial processes are run.

Related Objects

GL_DAILY_RATES is integral to the currency conversion architecture. Key related objects include:

• FND_CURRENCIES: Provides the valid list of currencies referenced by the FROM_CURRENCY and TO_CURRENCY columns.
• GL_DAILY_CONVERSION_TYPES: Defines the valid conversion types (e.g., 'Corporate') used in the CONVERSION_TYPE column.
• GL_JE_BATCHES / GL_JE_HEADERS / GL_JE_LINES: Journal tables that rely on rates from GL_DAILY_RATES for automatic currency conversion.
• GL_RECONCILIATION_SETS (for Revaluation): The revaluation process uses rates from this table to calculate unrealized gains and losses.
• Key APIs: Procedures within packages like GL_CURRENCY_API use this table to fetch and validate rates for various GL subledger accounting processes.