Search Results gl_xchg_rte




Overview
Explore in AI Chat

Overview

The GL_XCHG_RTE table is a core data object within the Oracle E-Business Suite (EBS), specifically for the Process Manufacturing Financials (GMF) module. It serves as the primary repository for storing daily foreign exchange rates. Its fundamental role is to provide the rate data necessary for currency conversion in financial transactions, journal entries, and cost calculations within a multi-currency manufacturing environment. By maintaining a historical record of rates keyed by date and type, it ensures accurate financial reporting, inventory valuation, and intercompany settlements that comply with accounting standards.

Key Information Stored

The table's structure is designed to uniquely identify a specific exchange rate for a given point in time. As defined by its primary key constraint (GL_XCHG_RTE_PK), the critical columns are: TO_CURRENCY_CODE, FROM_CURRENCY_CODE, RATE_TYPE_CODE, and EXCHANGE_RATE_DATE. This combination allows the system to store multiple rate types (e.g., Corporate, Spot) for any currency pair on any specific date. While the excerpt does not list all columns, the table typically contains the EXCHANGE_RATE column itself, which holds the multiplier to convert one unit of the 'from' currency into the 'to' currency. Additional descriptive columns, such as those for rate source or creation metadata, are commonly present in this type of table.

Common Use Cases and Queries

The primary use case is the retrieval of a valid exchange rate for financial processing. A common query pattern involves joining this table to transactional data (e.g., invoices, journals) to convert amounts. For example, to find the corporate rate for converting USD to EUR on a specific date:

  • SELECT exchange_rate FROM gl_xchg_rte WHERE from_currency_code = 'USD' AND to_currency_code = 'EUR' AND rate_type_code = 'Corporate' AND exchange_rate_date = TO_DATE('2023-10-01', 'YYYY-MM-DD');

Reporting use cases include analyzing rate histories for audit purposes, reconciling translated financial statements, and validating the rates used in month-end cost rollups. Batch processes within GMF and General Ledger (GL) will query this table extensively during period-close procedures.

Related Objects

As a foundational table for currency data, GL_XCHG_RTE is referenced by numerous other objects in the GMF and GL modules. It is directly linked to via its primary key. Related tables likely include GL_DAILY_RATES (in the GL schema), which may share a similar purpose for core GL functionality. Within GMF, tables storing transactional data with currency amounts, such as cost tables or inventory valuation tables, will have foreign key relationships or logical dependencies on GL_XCHG_RTE. The documented primary key (GL_XCHG_RTE_PK) on the columns TO_CURRENCY_CODE, FROM_CURRENCY_CODE, RATE_TYPE_CODE, and EXCHANGE_RATE_DATE is the anchor point for these relationships, ensuring data integrity for all downstream currency conversions.