Skip to main content
OracleOps AI
← All tables
Oracle Fusion/Financials/GL

GL_LEDGERS

Ledger definitions — chart of accounts, currency, calendar and accounting method for a ledger.

Key Columns

LEDGER_IDNAMELEDGER_CATEGORY_CODECHART_OF_ACCOUNTS_IDCURRENCY_CODEPERIOD_SET_NAMEACCOUNTED_PERIOD_TYPE

Common Joins

GL_JE_HEADERSvia LEDGER_ID

Journals posted to the ledger.

GL_BALANCESvia LEDGER_ID

Account balances maintained for the ledger.

Used In

GLSubledger Accounting

Notes

LEDGER_CATEGORY_CODE distinguishes primary, secondary and reporting-currency ledgers.

Related

GL ledgers, periods and journal import

A ledger (GL_LEDGERS) has a chart of accounts, currency and calendar; period open/close is GL_PERIOD_STATUSES per application. External journals stage in GL_INTERFACE for Import Journals, which creates GL_JE_BATCHES / GL_JE_HEADERS / GL_JE_LINES, and GL_IMPORT_REFERENCES keeps the drilldown to the subledger.

Ask Oracle AI about GL_LEDGERS