Oracle Fusion · Data dictionary
GL_DAILY_CONVERSION_TYPES
General LedgerUsed in 20 subject areas2 reporting columns
General Ledger (GL) — type / category reference.
Primary key: CONVERSION_TYPE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CONVERSION_TYPE | PK | ○ | Type of conversion. |
| DESCRIPTION | ● | Description. | |
| USER_CONVERSION_TYPE | ● | Type of user conversion. |
6 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_CONVERSION_TYPES.
- AP Financial System Parameters Report
- Revaluation Rules Report
- GL Daily Rates
- Unrealized Foreign Currency Revaluation Report
- Global Intercompany Balances Report
- AP Disbursements 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 - New COGS and Gross Margin Details Real Time
- Fiscal Document Capture Transactions Real Time
- Payables Invoices - Holds Real Time
- Payables Invoices - Installments Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Payables Invoices - Trial Balance Real Time
- Payables Payments - Disbursements Real Time
- Payables Payments - Payment History Real Time
- Receivables - Adjustments Real Time
- Receivables - Credit Memo Applications Real Time
- Receivables - Customer Real Time
- Receivables - Miscellaneous Receipts Real Time
- Receivables - Payment Schedules Real Time
- Receivables - Receipt Conversion Rate Adjustments Real Time
- Receivables - Receipts Details Real Time
- Receivables - Standard Receipts Application Details Real Time
- Receivables - Transactions Real Time
- Sourcing - Program Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for GL_DAILY_CONVERSION_TYPES?
We ship parameterized SQL, BICC config, and dbt models you own.