Search Results gmf_xla_extract_headers_u2

Overview

GMF.GMF_XLA_EXTRACT_HEADERS is the Subledger Accounting (SLA) extract headers table within the Process Manufacturing (GMF) schema in Oracle EBS 12.1.1 and 12.2.2. It functions as the staging repository for accounting event data generated from inventory transactions performed in process inventory organizations. When inventory transactions are processed, all data required for accounting and journal entry creation is consolidated and stored in this table. Subsequently, the SLA accounting program extracts this information to create journal entries in the Subledger Accounting module, which are then transferred to the General Ledger.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. Its design supports high-volume transaction processing typical of process manufacturing environments where material movements drive cost accounting and financial postings. From a data modeling perspective, the mined foreign key structure suggests a standalone classification under Data Vault heuristics, though the presence of event-driven transaction details indicates it may function as a link table connecting inventory transactions to SLA accounting events. This classification should be treated as a modeling suggestion rather than a definitive architectural designation.

Key Information Stored

The primary surrogate key is HEADER_ID, defined by the unique index GMF_XLA_EXTRACT_HEADERS_U1. The table's business key is represented by the composite unique index GMF_XLA_EXTRACT_HEADERS_U2, spanning LEGAL_ENTITY_ID, LEDGER_ID, VALUATION_COST_TYPE_ID, TRANSACTION_ID, EVENT_CLASS_CODE, and EVENT_TYPE_CODE. This composite uniqueness ensures that no duplicate accounting extract records exist for the same legal entity, ledger, valuation cost type, transaction, and event classification combination.

Critical columns include:

• EVENT_ID — the SLA event identifier that links the extract record to the accounting event model.
• ENTITY_CODE and EVENT_CLASS_CODE / EVENT_TYPE_CODE — classify the accounting event for SLA processing rules.
• LEGAL_ENTITY_ID and LEDGER_ID — identify the legal entity and ledger for which accounting is performed; LEGAL_ENTITY_ID references FV_LEGAL_ENTITIES.
• TRANSACTION_ID — the originating transaction identifier from MTL_MATERIAL_TRANSACTIONS.
• TRANSACTION_SOURCE_TYPE_ID — references MTL_TXN_SOURCE_TYPES, identifying the source of the transaction.
• VALUATION_COST_TYPE_ID and VALUATION_COST_TYPE — determine the cost valuation basis for the transaction.
• TRANSACTION_DATE and ACTUAL_POSTING_DATE — capture transaction timing and posting dates for period-based accounting.
• TRANSACTION_VALUE / TRANSACTION_VALUE_RAW and TRANSACTION_CURRENCY — hold monetary amounts and currency information.
• ACCOUNTED_FLAG — indicates whether the record has been processed by SLA.
• ORGANIZATION_ID, INVENTORY_ITEM_ID, and LOT_NUMBER — provide inventory context for the transaction.

Common Use Cases and Queries

Typical usage centers on monitoring unprocessed accounting events, reconciling inventory transactions to SLA journal entries, and auditing cost accounting data. A common query identifies records awaiting SLA processing:

• SELECT header_id, transaction_id, event_class_code, transaction_date, accounted_flag FROM gmf.gmf_xla_extract_headers WHERE accounted_flag = 'N';
• Reporting by ledger and period: SELECT ledger_id, valuation_cost_type_id, COUNT(*) FROM gmf.gmf_xla_extract_headers WHERE transaction_date BETWEEN :start_date AND :end_date GROUP BY ledger_id, valuation_cost_type_id;
• Joining to MTL_MATERIAL_TRANSACTIONS on TRANSACTION_ID to retrieve item and quantity details for reconciliation.
• Isolating extract records by legal entity for intercompany accounting analysis using LEGAL_ENTITY_ID and XFER_LEGAL_ENTITY_ID.

These patterns support period-close activities, SLA troubleshooting, and cost accounting audits where discrepancies between inventory subledger and general ledger must be investigated.

Related Objects

• FV_LEGAL_ENTITIES — joined via LEGAL_ENTITY_ID to resolve legal entity names and registrations.
• MTL_TXN_SOURCE_TYPES — joined via TRANSACTION_SOURCE_TYPE_ID to identify transaction origins.
• MTL_MATERIAL_TRANSACTIONS — joined via TRANSACTION_ID for inventory transaction details.
• GMF_XLA_EXTRACT_LINES — the companion lines table providing distribution-level detail for each header.
• XLA_EVENTS — SLA event model table linked through EVENT_ID.
• XLA_AE_HEADERS and XLA_AE_LINES — SLA journal entry tables generated from extract data.
• GL_LEDGERS — joined via LEDGER_ID for ledger context and chart of accounts information.