Search Results element_sequence

Overview

GL_CONSOLIDATION_ACCOUNTS is a General Ledger (GL) schema table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the account range definitions used when consolidating balances from one or more source ledgers into a target ledger. Each row defines a single account range element, expressed through low and high values across the key flexfield segments, attached to a specific consolidation definition and consolidation run. The table therefore acts as the filtering and mapping layer that the GL Consolidation program applies when transferring balances between ledgers. From a Data Vault modeling perspective, the documented foreign key structure suggests classifying GL_CONSOLIDATION_ACCOUNTS as a link entity, because it associates a consolidation definition (via CONSOLIDATION_ID) with source ledger and account range attributes rather than representing an independent business concept.

Key Information Stored

The table carries 69 documented columns. The most significant are summarized below.

• CONSOLIDATION_RUN_ID — identifies the consolidation run instance to which the account range belongs.
• CONSOLIDATION_ID — foreign key to GL_CONSOLIDATION, identifying the consolidation definition (source/target ledger mapping) that owns this range.
• ELEMENT_SEQUENCE — ordering sequence for the range element within the consolidation run.
• FROM_LEDGER_ID — identifies the source ledger from which balances are consolidated.
• SEGMENT1_LOW … SEGMENT30_LOW and SEGMENT1_HIGH … SEGMENT30_HIGH — paired low/high bounds for each of the 30 accounting flexfield segments, defining the inclusive account range to be consolidated.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

The documented primary key is GL_CONSOLIDATION_ACCOUNTS_PK, comprising CONSOLIDATION_RUN_ID, CONSOLIDATION_ID, and ELEMENT_SEQUENCE. The unique index GL_CONSOLIDATION_ACCOUNTS_U1 carries the same combination, making it the business-key candidate. In practice, CONSOLIDATION_RUN_ID and ELEMENT_SEQUENCE are surrogate-style run identifiers, while the meaningful business identity is the consolidation definition combined with the defined account range.

Common Use Cases and Queries

Typical scenarios include auditing which accounts were included in a consolidation run, reproducing consolidation results, and building reporting extracts of source-to-target balance transfers.

• Listing account ranges for a given consolidation definition:

  SELECT consolidation_run_id, element_sequence,
         segment1_low, segment1_high, segment2_low, segment2_high
  FROM   gl_consolidation_accounts
  WHERE  consolidation_id = :p_consolidation_id
  ORDER BY element_sequence;

• Identifying source ledgers referenced by a run:

  SELECT DISTINCT from_ledger_id
  FROM   gl_consolidation_accounts
  WHERE  consolidation_run_id = :p_run_id;

• Joining to GL_CONSOLIDATION to display definition names alongside ranges for reporting or reconciliation.

Because range columns are stored one pair per segment, queries that need to evaluate whether a specific account falls inside a range must compare each segment value against its corresponding _LOW and _HIGH columns.

Related Objects

• GL_CONSOLIDATION — parent definition table; joined via CONSOLIDATION_ID.
• GL_CONSOLIDATION_ACCOUNTS self-referencing key FROM_LEDGER_ID linking to the ledger master.
• GL_LEDGERS — resolves FROM_LEDGER_ID to a ledger name and chart of accounts.
• GL_CONSOLIDATION_SETS and consolidation run tables — provide the run context for CONSOLIDATION_RUN_ID.
• GL_BALANCES — the balance source filtered by the account ranges during consolidation.
• GL_ACCOUNT_FLEXFIELD / FND_FLEX_VALUES — supply valid segment values for the SEGMENTn_LOW/HIGH columns.

Together these objects support the end-to-end consolidation process, from definition through execution and resulting balance transfer.