EBS Reference

GL_LEDGERS

Schema: GLmaster

One row per ledger, tying together the four Cs — currency, calendar, chart of accounts, and accounting convention; the R12 replacement for the 11i sets-of-books table, and the ledger context every operating unit resolves to

Module: FoundationNot org-partitioned

What the badges mean

master: Data class: what the table holds — master data, transaction documents, control/configuration, interface/staging, or an APPS-schema view.

Fields

9 fields · 1 key

Table fields: position, field name, description, data type, and flags. 9 fields.
#	Field	Description	Type	Flags
1	LEDGER_ID	Surrogate key of the ledger — what operating units and subledgers point at	NUMBER	Key
2	NAME	Ledger name (unique)	VARCHAR2
3	SHORT_NAME	Ledger short name (unique)	VARCHAR2
4	DESCRIPTION	Ledger description	VARCHAR2
5	LEDGER_CATEGORY_CODE	Primary, secondary, or reporting-currency ledger — filter to primary for most analytics	VARCHAR2
6	CURRENCY_CODE	The ledger currency	VARCHAR2
7	CHART_OF_ACCOUNTS_ID	The chart of accounts (accounting flexfield structure) the ledger posts against	NUMBER
8	PERIOD_SET_NAME	The accounting calendar the ledger runs on	VARCHAR2
9	ACCOUNTED_PERIOD_TYPE	Which period type within the calendar the ledger accounts in	VARCHAR2

Field provenance: hand-curated. 1 key field.

Boilerplate SQL

Starting point for reading GL_LEDGERSon Databricks — real DATE columns need no conversion, and the org anchor and the LAST_UPDATE_DATE watermark are already in place. Set your Unity Catalog location, schema, and org values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogSchemaLedgerwatermark

Include optional filters (2)

-- ============================================================
-- Table  : GL_LEDGERS — One row per ledger, tying together the four Cs — currency, calendar, chart of accounts, and accounting convention; the R12 replacement for the 11i sets-of-books table, and the ledger context every operating unit resolves to
-- Purpose: Column-selected read of GL_LEDGERS — auto-generated from field metadata
-- Grain  : One row per LEDGER_ID
-- Notes  : Auto-generated skeleton for Oracle EBS R12 data landed in your lakehouse. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts.
-- ============================================================
SELECT
  t.LEDGER_ID AS "Surrogate key of the ledger — what operating units and subledgers point at",
  t.NAME AS "Ledger name (unique)",
  t.SHORT_NAME AS "Ledger short name (unique)",
  t.DESCRIPTION AS "Ledger description",
  t.LEDGER_CATEGORY_CODE AS "Primary, secondary, or reporting-currency ledger — filter to primary for most analytics",
  t.CURRENCY_CODE AS "The ledger currency",
  t.CHART_OF_ACCOUNTS_ID AS "The chart of accounts (accounting flexfield structure) the ledger posts against",
  t.PERIOD_SET_NAME AS "The accounting calendar the ledger runs on",
  t.ACCOUNTED_PERIOD_TYPE AS "Which period type within the calendar the ledger accounts in"
FROM <catalog>.<schema>.GL_LEDGERS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.LEDGER_ID = <LEDGER_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.LEDGER_ID;

4 parameters not filled: <catalog>, <schema>, <LEDGER_ID>, <watermark>

Relationships

1-hop neighbors — click a table to navigate there. FND lookup decode and translation edges are highlighted; they’re the joins newcomers most often get wrong.

Join details

GL_CODE_COMBINATIONSGL_LEDGERSforeign key · N:M
ON GL_CODE_COMBINATIONS.CHART_OF_ACCOUNTS_ID = GL_LEDGERS.CHART_OF_ACCOUNTS_ID

Browse more Foundationtables →