Oracle Fusion · Data dictionary
GL_LEDGERS
General LedgerUsed in 104 subject areas10 reporting columns
General Ledger (GL) — ledger definitions. The accounting setup for each ledger: chart of accounts, calendar, currency, accounting method.
Primary key: LEDGER_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTED_PERIOD_TYPE | ● | Type of accounted period. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| DESCRIPTION | ● | Description. | |
| LEDGER_CATEGORY_CODE | ● | Code identifying the ledger category. | |
| LEDGER_ID | PK | ○ | Ledger identifier for the row. |
| NAME | ● | Name. | |
| PERIOD_SET_NAME | ● | Name of the period set. | |
| SHORT_NAME | ● | Name of the short. | |
| SLA_ACCOUNTING_METHOD_CODE | ● | Code identifying the sla accounting method. | |
| SLA_ACCOUNTING_METHOD_TYPE | ● | Type of sla accounting method. | |
| SUSPENSE_ALLOWED_FLAG | ● | Indicator (Y/N) for the suspense allowed. |
42 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_LEDGERS.
- AP Financial System Parameters Report
- Asset Book Controls Report
- GL Period Status Report
- Lease BU Configurations Report
- Ledger Options Report
- Manual Subledger Journals Report
- AHCS Create Accounting Errors Report
- AHCS Create Accounting 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
- GL Journal Unposted Report
- General Ledger Report for China Secondary Ledgers
- General Ledger Trial Balance Monthly Movements Report
- Journal Approval Audit History Report
- Journal Entry Reversal Detail Report
- Journal Voucher Report for China Secondary Ledger Report
- Ledger Comparison Report
- Pending Transaction Detail Report
- Unrealized Foreign Currency Revaluation Report
- Unrealized Foreign Currency Revaluation Report - All revaluations
- Unrealized Foreign Currency Revaluation Report - Banks
- Vietnam Journal Voucher Report
- Yevmiye Defteri - Electronic
- Global Intercompany Balances Report
- AP Disbursements Report
- SLA Payables Account Analysis 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.
- Budgetary Control - Transactions Real Time
- Cash Management - External Cash Transactions Real Time
- Costing - COGS and Gross Margin Real Time
- Costing - Cost Accounting Period Close Real Time
- Costing - Cost Accounting Real Time
- Costing - Cost Rollup Details Real Time
- Costing - Inventory Valuation Real Time
- Costing - Item Cost Real Time
- Costing - Landed Costs Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Costing - Period Intransit Inventory Valuation Real Time
- Costing - Period Inventory Valuation Real Time
- Costing - Receipt Accounting Period Close Real Time
- Costing - Receipt Accounting Real Time
- Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time
- Costing - Supply Chain Cost Rollup Real Time
- Costing - Transfer Order Receipt Landed Cost Charges Real Time
- Costing - Where Used Details Real Time
- Costing - Work Order Costs Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
Need the extract + dbt staging for GL_LEDGERS?
We ship parameterized SQL, BICC config, and dbt models you own.