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 Licensing 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. You can't join across them in OTBI, the owned conformed model joins them on shared 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
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Headers Real Time
- Inventory - Inventory Transfer Order 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