Search Results trx_hdr_table




Overview
Explore in AI Chat

Overview

XLA_GL_JE_AEL_V is an APPS-owned database view in Oracle E-Business Suite 12.1.1 and 12.2.2 that belongs to the Subledger Accounting (XLA) product. Its purpose is to expose General Ledger journal lines in the standardized "Accounting Event Line" (AEL) format used by the Subledger Accounting and ETRM reporting frameworks. In effect, the view presents GL journal data as if it were subledger accounting line data, giving tools and reports a common column layout that can be queried across the accounting stack.

The view is defined with a constant APPLICATION_ID of 101 (the internal identifier for the General Ledger application) and a constant TRX_HDR_TABLE value of 'JRNL', indicating that the source transaction header is a GL journal. This makes XLA_GL_JE_AEL_V a bridge that lets the XLA reporting and drill-down machinery treat GL journal entries as accounting event lines.

Underlying Base Objects

The documented referenced base objects are FND_GLOBAL (package), FND_LOOKUPS (view), GL_JE_HEADERS (synonym), and GL_JE_LINES (synonym). The view text joins FND_LOOKUPS, GL_JE_LINES, and GL_JE_HEADERS:

The join condition links each line to its header on JE_HEADER_ID, so the view returns one row per GL journal line.

Key Columns

  • APPLICATION_ID — constant 101, identifying the General Ledger application.
  • TRX_HDR_TABLE — constant 'JRNL', the transaction header type.
  • TRX_HDR_ID — the GL JE_HEADER_ID.
  • SET_OF_BOOKS_ID — the ledger identifier from the journal header.
  • GL_DATE — derived from JEH.DATE_CREATED.
  • ACCT_LINE_TYPE / ACCT_LINE_TYPE_NAME — lookup-based line classification from FND_LOOKUPS.
  • PERIOD_NAME, STATUS, CURRENCY_CODE — journal header attributes.
  • AE_LINE_REFERENCE — concatenation of L.MEANING and JE_LINE_NUM.
  • AE_LINE_REFERENCE_INTERNAL — the JE_LINE_NUM left-padded to 15 characters with zeros via LPAD(JEL.JE_LINE_NUM, 15, '0'). This is the internal, zero-padded line reference the user searched for.
  • CODE_COMBINATION_ID — the accounting flexfield combination.
  • ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR — entered and accounted debit/credit amounts.

Common Use Cases and Queries

The view is typically used for AEL-style reporting, drill-down from subledger accounting to GL, and reconciliation between subledger and GL journal lines. A representative query retrieving internal line references for a ledger follows:

  • SELECT AE_LINE_REFERENCE_INTERNAL, AE_LINE_REFERENCE, PERIOD_NAME, STATUS, CURRENCY_CODE, ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR FROM APPS.XLA_GL_JE_AEL_V WHERE SET_OF_BOOKS_ID = :ledger_id AND PERIOD_NAME = :period;
  • Filtering by TRX_HDR_ID (JE_HEADER_ID) to retrieve all lines for a specific journal.
  • Joining to GL_CODE_COMBINATIONS on CODE_COMBINATION_ID to obtain account segment values.
  • Aggregating ACCOUNTED_DR and ACCOUNTED_CR per period for reconciliation against subledger balances.

Because the view relies on APPS synonyms and FND_LOOKUPS, queries should be run in the APPS schema or with appropriate grants.