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