Search Results gmf_xla_extract_headers




Overview
Explore in AI Chat

Overview

GMF_XLA_EXTRACT_HEADERS is the Subledger Accounting (SLA) extract headers table owned by the GMF schema in Oracle E-Business Suite, associated with the Process Manufacturing Financials product family. It is classified as VALID in the ETRM repository and contains 53 documented columns in release 12.2.2.

The table serves as the staging and extraction repository for accounting-relevant transaction data originating from process inventory organizations. When process manufacturing transactions occur, the necessary accounting attributes are captured and stored in this table. When the SLA accounting program executes, this data is consumed to create subledger journal entries and transfer them to the General Ledger. The table therefore acts as the bridge between high-volume process manufacturing inventory activity and the corporate accounting engine.

From a Data Vault modeling perspective (heuristic, mined from the FK structure), this object is classified as standalone. This suggests it behaves as a self-contained hub-like entity with its own surrogate key, rather than sitting strictly within a link or satellite construct. Modelers should treat this classification as a suggestion; the table carries both descriptive attributes and foreign-key-style references to legal entities and transaction sources, so it could also be modeled as a hub with dependent satellites depending on enterprise requirements.

Key Information Stored

The surrogate primary key is HEADER_ID, enforced by the unique index GMF_XLA_EXTRACT_HEADERS_U1. A second unique index, GMF_XLA_EXTRACT_HEADERS_U2, defines a composite business-key candidate spanning LEGAL_ENTITY_ID, LEDGER_ID, VALUATION_COST_TYPE_ID, TRANSACTION_ID, EVENT_CLASS_CODE, and EVENT_TYPE_CODE — reflecting the accounting-event grain of each extract row.

Common Use Cases and Queries

Typical usage centers on reconciliation, SLA diagnostics, and cost accounting analysis. Analysts query this table to verify that inventory transactions have been extracted and accounted, to trace valuation discrepancies, and to report transaction values by legal entity, ledger, or organization.

A representative query pattern isolates unaccounted extracts for a given ledger:

SELECT header_id, transaction_id, event_class_code, event_type_code,
       transaction_value, transaction_currency, accounted_flag
FROM   gmf.gmf_xla_extract_headers
WHERE  ledger_id = :ledger_id
AND    NVL(accounted_flag,'N') = 'N';

Aggregation by event classification is commonly used to compare extract totals against SLA journal balances:

SELECT event_class_code, event_type_code,
       COUNT(*) rows_cnt, SUM(transaction_value) total_value
FROM   gmf.gmf_xla_extract_headers
WHERE  transaction_date BETWEEN :from_date AND :to_date
GROUP  BY event_class_code, event_type_code;

Related Objects

The FK metadata documents two direct references, supplemented by the broader SLA integration landscape:

  • FV_LEGAL_ENTITIES — joined on LEGAL_ENTITY_ID to resolve legal entity attributes for reporting.
  • MTL_TXN_SOURCE_TYPES — joined on TRANSACTION_SOURCE_TYPE_ID to identify the source of each transaction.
  • GMF_XLA_EXTRACT_LINES — the companion lines table that stores the individual accounting line distributions generated from each header.
  • XLA_EVENTS — the SLA event registry; EVENT_ID in the header correlates to the accounting event created for the transaction.
  • XLA_AE_HEADERS and XLA_AE_LINES — the downstream SLA journal header and line tables populated from extract data.
  • MTL_MATERIAL_TRANSACTIONS — the inventory transaction source supplying TRANSACTION_ID and related item, lot, and quantity facts.
  • GL_LEDGERS — joined on LEDGER_ID to obtain ledger name, chart of accounts, and currency context.

Together these objects form the end-to-end path from process inventory transaction through SLA extract to final general ledger posting.