Search Results journal_id




Overview
Explore in AI Chat

Overview

The GL_ELIM_ACCOUNTS_MAP table is a core data object within the Oracle E-Business Suite General Ledger module, specifically designed to support the intercompany elimination process. In financial consolidation, transactions between entities within the same corporate group must be eliminated to prevent double-counting in consolidated financial statements. This table acts as a mapping repository, storing the relationship between the original journal entry lines from subsidiary ledgers and the corresponding elimination journal entries created in the consolidation ledger. Its role is critical for maintaining audit trails, ensuring the transparency and reversibility of elimination entries, and supporting accurate consolidated reporting in both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary key, which consists of JOURNAL_ID and LINE_NUMBER. This composite key uniquely identifies each mapping record. The JOURNAL_ID column typically stores the identifier of the elimination journal entry created in the consolidation ledger. The LINE_NUMBER column corresponds to the specific line within that elimination journal. While the provided ETRM metadata is concise, standard implementation patterns suggest the table also contains foreign key references to the source subsidiary journal lines (e.g., from GL_JE_LINES). This allows the system to trace which original transaction lines were eliminated by a given consolidation journal line, thereby storing the essential linkage between source and elimination data.

Common Use Cases and Queries

The primary use case is tracing and auditing intercompany eliminations. During period-end consolidation, accountants and auditors need to verify which underlying transactions were eliminated. A common query involves joining this table to the journal headers and lines tables for both the source and elimination entries. For example, to list all elimination journal entries and their source details, one might query GL_ELIM_ACCOUNTS_MAP, joining it to GL_JE_HEADERS and GL_JE_LINES on the relevant JOURNAL_ID and LINE_NUMBER. This is vital for reconciliation, troubleshooting consolidation errors, and generating reports that detail the composition of elimination adjustments. The data is also referenced by standard consolidation reports and can be used to build custom audit trails.

Related Objects

  • GL_JE_HEADERS & GL_JE_LINES: The JOURNAL_ID and LINE_NUMBER in GL_ELIM_ACCOUNTS_MAP are foreign keys referencing the journal entry headers and lines, specifically those of the elimination journals created during consolidation. The table GL_JE_LINES is likely the primary parent table for these foreign key relationships.
  • Consolidation Workbench & Programs: The table is populated and managed by the consolidation engine (e.g., programs invoked from the Consolidation Workbench) when generating elimination sets. It is a key supporting object for the consolidation process.
  • Primary Key Constraint: GL_ELIM_ACCOUNTS_MAP_PK is the documented primary key constraint on the columns (JOURNAL_ID, LINE_NUMBER).