Oracle Fusion · Data dictionary
GL_DAILY_RATES
General LedgerUsed in 10 subject areas1 reporting columns
General Ledger (GL).
Primary key: FROM_CURRENCY, TO_CURRENCY, CONVERSION_DATE, CONVERSION_TYPE
Joins (inferred from key columns): CONVERSION_TYPE → GL_DAILY_CONVERSION_TYPES
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CONVERSION_DATE | PK | ○ | Conversion date. |
| CONVERSION_RATE | ● | Conversion rate. | |
| CONVERSION_TYPE | PK | ○ | Type of conversion. |
| FROM_CURRENCY | PK | ○ | From currency. |
| TO_CURRENCY | PK | ○ | To currency. |
17 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to GL_DAILY_RATES.
- GL Daily Rates
- GL Balance Tracking for Contracts Report
- Journal Approval Audit History Report
- Revaluation Report
- Unrealized Foreign Currency Revaluation Report
- Unrealized Foreign Currency Revaluation Report - All revaluations
- Unrealized Foreign Currency Revaluation Report - Banks
- Global Intercompany Balances Report
- Lease Activity Detail Report
- Lease Details Report
- Lease Disclosure Report
- AP Disbursements Report
- Projects Global vs Local CER Report
- Payables Open Items Revaluation Report
- Customer Balances Revaluation Report
- Receivables Open Items Revaluation Report
- Receivables Projected Gains and Losses Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Costing - Cost Accounting Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Costing - Receipt Accounting Real Time
- Costing - Work Order Costs Real Time
- Inventory - Inventory Transfer Order Real Time
- Order Management - Fulfillment Lines Real Time
- Order Management - Order Headers Real Time
- Procurement - Purchasing Real Time
- Procurement - Requisitions Real Time
- Supply Chain Financial Orchestration Real Time
Need the extract + dbt staging for GL_DAILY_RATES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table