Search Results gl_elimination_journals




Overview
Explore in AI Chat

Overview

GL.GL_ELIMINATION_JOURNALS is a General Ledger table that stores the definitions of intercompany elimination journals in Oracle E-Business Suite 12.1.1 and 12.2.2. Elimination journals are the mechanism by which General Ledger consolidates balances across balancing segments or intercompany entities, generating reversing or offsetting entries so that intra-entity balances net to zero at the consolidated level. Each row in this table represents one elimination journal definition belonging to a specific elimination set, and it drives the journal creation that occurs when the elimination process is executed against a consolidation ledger.

The object is classified in the GL schema as a transactional configuration table with a composite primary key and two unique indexes. From a Data Vault modeling perspective (heuristic, based on foreign key structure), GL_ELIMINATION_JOURNALS is best understood as a link table: it sits between elimination sets (GL_ELIMINATION_SETS) and the currency dimension (FND_CURRENCIES), associating a journal definition to a parent elimination set and a currency. Its descriptive attributes — journal name, category, amount type — can be modeled as satellite content attached to that link. The table is stamped with the standard EBS WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and carries fifteen descriptive flexfield (DFF) attribute columns for client-specific extensions.

Key Information Stored

The documented physical schema for 12.2.2 shows 27 columns. The most operationally significant among them are:

  • ELIMINATION_SET_ID and JOURNAL_ID — together forming the composite primary key GL_ELIMINATION_JOURNALS_PK. ELIMINATION_SET_ID identifies the parent elimination set; JOURNAL_ID is an internal identifier for the journal definition.
  • JOURNAL_NAME — the user-visible name of the elimination journal. Combined with ELIMINATION_SET_ID, this forms the business-key unique index GL_ELIM_JOURNALS_U2, guaranteeing that journal names are unique within each elimination set.
  • JE_CATEGORY — the journal entry category (for example, an elimination or consolidation category) applied to entries generated from this definition.
  • CURRENCY_CODE — the currency in which the elimination journal is denominated; this column is a foreign key to FND_CURRENCIES.
  • AMOUNT_TYPE — recorded amount basis (for example, entered versus accounted amount) governing how balances are selected for elimination.
  • CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield context column and segment values, used for client-specific reporting and extensions.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard audit (WHO) columns populated automatically by EBS.

Note that the composite key column pair also appears in the unique index GL_ELIM_JOURNALS_U1, reinforcing the 1:1 relationship between a journal id and its elimination set context.

Common Use Cases and Queries

Typical reporting and diagnostic scenarios center on tracing which journals belong to a given elimination set and on reconciling currency and category configuration.

  • List all journals within an elimination set:
SELECT j.journal_id, j.journal_name, j.je_category,
       j.currency_code, j.amount_type
FROM   gl.gl_elimination_journals j
WHERE  j.elimination_set_id = :p_set_id;
  • Join to the elimination set header to display the set name alongside each journal:
SELECT s.elimination_set_name, j.journal_name, j.currency_code
FROM   gl.gl_elimination_journals j,
       gl.gl_elimination_sets s
WHERE  j.elimination_set_id = s.elimination_set_id;
  • Currency validation — confirm the currency code resolves to a defined currency:
SELECT j.journal_name, c.name
FROM   gl.gl_elimination_journals j,
       fnd_currencies c
WHERE  j.currency_code = c.currency_code;

Common reporting uses include consolidation audit trails, intercompany elimination analysis, DFF-based custom reporting on ATTRIBUTEn columns, and setup validation during ledger implementation.

Related Objects

The following referenced objects are the most significant for join-based access to this table:

  • GL_ELIMINATION_SETS — parent elimination set header; joined on ELIMINATION_SET_ID. Every elimination journal belongs to exactly one set.
  • FND_CURRENCIES — currency definitions; joined on CURRENCY_CODE.
  • GL_ELIMINATION_JOURNALS_PK — the primary key index, used for direct lookups by (ELIMINATION_SET_ID, JOURNAL_ID).
  • GL_ELIM_JOURNALS_U1 / GL_ELIM_JOURNALS_U2 — unique indexes enforcing business-key uniqueness on (ELIMINATION_SET_ID, JOURNAL_ID) and (ELIMINATION_SET_ID, JOURNAL_NAME).

Because GL_ELIMINATION_JOURNALS is a configuration table, its principal dependency is upward to the elimination sets and currency definitions it references. Downstream consumption occurs through the GL consolidation and elimination programs that read these definitions when generating elimination journal entries during period-end consolidation.