| layout | default |
|---|---|
| title | GL Daily Rates | Oracle EBS SQL Report |
| description | Daily currency conversion rates – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Daily, Rates, gl_daily_conversion_types, gl_daily_rates |
| permalink | /GL%20Daily%20Rates/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Daily currency conversion rates
From Currency, To Currency, Conversion Type, Conversion Date From, Conversion Date To
gl_daily_conversion_types, gl_daily_rates
GL Account Analysis 11i, CAC PO Price vs. Costing Method Comparison, GL Journals (Drilldown), GL Balance by Account Hierarchy, CAC Internal Order Shipment Margin
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | GL Daily Rates 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | GL_Daily_Rates.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/gl-daily-rates/ |
The GL Daily Rates report provides a comprehensive listing of daily currency exchange rates defined in the Oracle EBS system. It is an essential tool for multi-currency environments, ensuring that conversion rates for foreign currency transactions are accurate, complete, and compliant with corporate treasury policies. This report serves as a primary control for verifying the rates used in currency translation and revaluation processes.
- Treasury Management: Monitors exchange rate trends and ensures that corporate rates (e.g., daily spot rates, monthly average rates) are loaded correctly into the ERP.
- Transaction Audit: Verifies the specific exchange rate applied to a transaction on a given date, which is crucial when investigating currency variances in subledgers (AP/AR).
- Missing Rate Identification: Proactively checks for missing rates between currency pairs before period-end processes (like Revaluation or Translation) fail due to undefined rates.
- Intercompany Reconciliation: Ensures consistent exchange rates are being used across different legal entities for intercompany transactions.
- Audit Trail: Provides a historical record of exchange rates for tax and statutory reporting purposes.
GL_DAILY_RATES: The primary table storing the actual exchange rates. It contains theFROM_CURRENCY,TO_CURRENCY,CONVERSION_DATE, andCONVERSION_RATE.GL_DAILY_CONVERSION_TYPES: Stores the definitions of rate types (e.g., 'Corporate', 'Spot', 'User').FND_CURRENCIES: Used to validate currency codes and retrieve precision information.
- Rate Retrieval: The query selects from
GL_DAILY_RATESbased on the requested date range and currency pairs. - Type Resolution: Joins to
GL_DAILY_CONVERSION_TYPESto display the user-friendly conversion type name instead of the internal code. - Inverse Rates: Depending on the configuration, the system may store rates in one direction (e.g., USD to EUR) and calculate the inverse (EUR to USD) dynamically. The report typically shows the stored rate but may need to handle inverse logic if requested.
- Date Filtering: Strictly filters by
CONVERSION_DATEto show the rates active for the specific period of interest.
- From Currency: The source currency code (e.g., USD).
- To Currency: The target currency code (e.g., EUR).
- Conversion Type: The specific rate type to report on (e.g., Corporate, Spot).
- Conversion Date From/To: The date range for the report.
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics