EBS Reference

GL_CODE_COMBINATIONS

Schema: GLmaster

Every chart-of-accounts segment combination (CCID) stored once — the account string behind each SEGMENTn set; inventory accounting distributions and every journal line reference accounts through CODE_COMBINATION_ID

Module: FoundationNot org-partitioned

Notes

SEGMENT1–SEGMENT30 exist physically; which segments a chart uses — and what each means — is configuration, defined per chart of accounts (see quirks #flexfields). The catalog lists the first six.

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

14 fields · 1 key

Table fields: position, field name, description, data type, and flags. 14 fields.
#	Field	Description	Type	Flags
1	CODE_COMBINATION_ID	The CCID — the surrogate key every accounting distribution and journal line carries	NUMBER	Key
2	CHART_OF_ACCOUNTS_ID	The chart of accounts this combination belongs to	NUMBER
3	ACCOUNT_TYPE	Asset, liability, equity, revenue, or expense — from the natural-account segment	VARCHAR2
4	ENABLED_FLAG	Whether the combination is active	VARCHAR2
5	SUMMARY_FLAG	Whether this is a summary (rollup) account rather than a detail account	VARCHAR2
6	DETAIL_POSTING_ALLOWED_FLAG	Whether journals may post to the combination directly	VARCHAR2
7	START_DATE_ACTIVE	Effectivity start date	DATE
8	END_DATE_ACTIVE	Effectivity end date	DATE
9	SEGMENT1	Accounting flexfield segment 1 — meaning depends on the chart's configuration	VARCHAR2	Flex segment
10	SEGMENT2	Accounting flexfield segment 2	VARCHAR2	Flex segment
11	SEGMENT3	Accounting flexfield segment 3	VARCHAR2	Flex segment
12	SEGMENT4	Accounting flexfield segment 4	VARCHAR2	Flex segment
13	SEGMENT5	Accounting flexfield segment 5	VARCHAR2	Flex segment
14	SEGMENT6	Accounting flexfield segment 6 (SEGMENT7–30 exist physically; catalog shows the first six)	VARCHAR2	Flex segment

Field provenance: hand-curated. 1 key field.

Boilerplate SQL

Starting point for reading GL_CODE_COMBINATIONSon 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

CatalogSchemaAccount combination (CCID)watermark

Include optional filters (2)

-- ============================================================
-- Table  : GL_CODE_COMBINATIONS — Every chart-of-accounts segment combination (CCID) stored once — the account string behind each SEGMENTn set; inventory accounting distributions and every journal line reference accounts through CODE_COMBINATION_ID
-- Purpose: Column-selected read of GL_CODE_COMBINATIONS — auto-generated from field metadata
-- Grain  : One row per CODE_COMBINATION_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.CODE_COMBINATION_ID AS "The CCID — the surrogate key every accounting distribution and journal line carries",
  t.CHART_OF_ACCOUNTS_ID AS "The chart of accounts this combination belongs to",
  t.ACCOUNT_TYPE AS "Asset, liability, equity, revenue, or expense — from the natural-account segment",
  t.ENABLED_FLAG AS "Whether the combination is active",
  t.SUMMARY_FLAG AS "Whether this is a summary (rollup) account rather than a detail account",
  t.DETAIL_POSTING_ALLOWED_FLAG AS "Whether journals may post to the combination directly",
  t.START_DATE_ACTIVE AS "Effectivity start date",
  t.END_DATE_ACTIVE AS "Effectivity end date",
  t.SEGMENT1 AS "Accounting flexfield segment 1 — meaning depends on the chart's configuration",  -- flexfield segment: concatenation is configuration-defined — see quirks guide #flexfields
  t.SEGMENT2 AS "Accounting flexfield segment 2",  -- flexfield segment: concatenation is configuration-defined — see quirks guide #flexfields
  t.SEGMENT3 AS "Accounting flexfield segment 3",  -- flexfield segment: concatenation is configuration-defined — see quirks guide #flexfields
  t.SEGMENT4 AS "Accounting flexfield segment 4",  -- flexfield segment: concatenation is configuration-defined — see quirks guide #flexfields
  t.SEGMENT5 AS "Accounting flexfield segment 5",  -- flexfield segment: concatenation is configuration-defined — see quirks guide #flexfields
  t.SEGMENT6 AS "Accounting flexfield segment 6 (SEGMENT7–30 exist physically; catalog shows the first six)"  -- flexfield segment: concatenation is configuration-defined — see quirks guide #flexfields
FROM <catalog>.<schema>.GL_CODE_COMBINATIONS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.CODE_COMBINATION_ID = <CODE_COMBINATION_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.CODE_COMBINATION_ID;

4 parameters not filled: <catalog>, <schema>, <CODE_COMBINATION_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
MTL_TRANSACTION_ACCOUNTSGL_CODE_COMBINATIONSforeign key · N:1
ON MTL_TRANSACTION_ACCOUNTS.REFERENCE_ACCOUNT = GL_CODE_COMBINATIONS.CODE_COMBINATION_ID
PO_DISTRIBUTIONS_ALLGL_CODE_COMBINATIONSforeign key · N:1
ON PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID = GL_CODE_COMBINATIONS.CODE_COMBINATION_ID

Browse more Foundationtables →