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.
Problems that run through this table