Search Results xla_ae_headers_gt




Overview
Explore in AI Chat

Overview

XLA_AE_HEADERS_GT is a global temporary table (indicated by the _GT suffix) in the XLA schema, the Subledger Accounting product of Oracle E-Business Suite. It functions as an interface table used during the accounting program's processing cycle, holding accounting entry headers in memory (session-scoped rows) before they are ultimately persisted into the permanent XLA_AE_HEADERS and XLA_AE_LINES tables. In Oracle EBS 12.1.1 and 12.2.2, this object is critical to the Create Accounting process, where subledger transactions are transformed into journal entries and transferred to General Ledger.

The table contains 135 documented columns spanning the header attributes required for journal entry creation and GL transfer. From a Data Vault modeling perspective, the heuristic classification is standalone, meaning it is not strongly tied as a hub, link, or satellite by foreign key structure. This suggests it should be treated as a transient staging structure rather than a normalized business entity.

Key Information Stored

The most operationally significant columns include:

The unique index XLA_AE_HEADERS_GT_U1 spans AE_HEADER_ID, LEDGER_ID, BALANCE_TYPE_CODE, and HEADER_NUM, identifying these as the composite business-key candidate set, distinct from the surrogate AE_HEADER_ID. Foreign keys reference GL_ENCUMBRANCE_TYPES (via ENCUMBRANCE_TYPE_ID) and FND_DOCUMENT_SEQUENCES (via DOC_SEQUENCE_ID).

Common Use Cases and Queries

Because this is a global temporary table, rows are visible only within the creating session, making direct ad-hoc querying outside the subledger accounting run largely ineffective. Typical reporting instead queries the permanent XLA_AE_HEADERS table, or joins this _GT table during diagnostic tracing of the Create Accounting concurrent program.

Representative diagnostic pattern:

  • Join XLA_AE_HEADERS_GT to XLA_AE_LINES_GT via AE_HEADER_ID to trace line detail within a processing session.
  • Filter on ACCOUNTING_ENTRY_STATUS_CODE to identify draft versus final entries.
  • Filter on GL_TRANSFER_STATUS_CODE to confirm successful GL posting before troubleshooting transfer errors.

Related Objects

  • XLA_AE_HEADERS — Permanent counterpart receiving the completed headers.
  • XLA_AE_LINES_GT — Line-level transient companion keyed by AE_HEADER_ID.
  • XLA_AE_LINES — Permanent line storage linked by AE_HEADER_ID.
  • GL_ENCUMBRANCE_TYPES — Lookup joined via ENCUMBRANCE_TYPE_ID.
  • FND_DOCUMENT_SEQUENCES — Join via DOC_SEQUENCE_ID for numbering.
  • GL_JE_HEADERS / GL_JE_LINES — Downstream GL destination for transferred entries.
  • Create Accounting concurrent program — Principal API/process populating this structure.