Oracle Fusion · Data dictionary
GL_CODE_COMBINATIONS
General LedgerUsed in 61 subject areas7 reporting columns
General Ledger (GL) — the Chart of Accounts. Every valid combination of accounting segments (company–cost-center–account–…).
Primary key: CODE_COMBINATION_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNT_TYPE | ● | Type of account. | |
| CHART_OF_ACCOUNTS_ID | ● | Identifier for the chart of accounts. | |
| CODE_COMBINATION_ID | PK | ● | Identifier for the code combination. |
| ENABLED_FLAG | ● | Indicator (Y/N) for the enabled. | |
| END_DATE_ACTIVE | ● | End date active. | |
| START_DATE_ACTIVE | ● | Start date active. | |
| SUMMARY_FLAG | ● | Indicator (Y/N) for the summary. |
68 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_CODE_COMBINATIONS.
- Oracle Fusion GL Trial Balance Report
- AP Financial System Parameters Report
- AP System Parameters Report
- Asset Book Controls Report
- Asset Category Book Report
- Ledger Options Report
- Revaluation Rules Report
- Credit Card Issuer Invoice Report
- Asset Category Exceptions Report
- FA to GL Reconciliation Report
- AHCS Create Accounting Errors Report
- AHCS Create Accounting Report
- Account Analysis Report
- Global SLA Account Analysis
- Account Ledger by Account Greece Report
- China Account Analysis Detail Report
- France GL Extract for ETAFI Report
- GL Balance Tracking for Licensing Contracts Report
- GL Detail by Budget Center with Project Detail
- General Ledger Report for China Secondary Ledgers
- General Ledger Trial Balance Monthly Movements Report
- Greece Daily Journal Book - Line Descriptions Report
- Journal Voucher Report for China Secondary Ledger Report
- Ledger Comparison Report
- Libro Partitario Report
- Revaluation Report
- Unrealized Foreign Currency Revaluation Report
- Unrealized Foreign Currency Revaluation Report - All revaluations
- Unrealized Foreign Currency Revaluation Report - Banks
- Vietnam Journal Voucher 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.
- Cash Management - External Cash Transactions Real Time
- Costing - Cost Accounting Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Headers Real Time
- Expenses - Expense Transactions Real Time
- Financials Common Module - Intercompany Transactions Real Time
- Fixed Assets - Asset Assignments Real Time
- Fixed Assets - Asset Balances Real Time
- Fixed Assets - Asset Depreciation Real Time
- Fixed Assets - Asset Retirements and Reinstatements Real Time
- Fixed Assets - Asset Transactions Real Time
- Fixed Assets - Asset Transfer Real Time
- General Ledger - Journals Real Time
- General Ledger - Transactional Balances Real Time
- Inventory - Inventory Transactions Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
Need the extract + dbt staging for GL_CODE_COMBINATIONS?
We ship parameterized SQL, BICC config, and dbt models you own.