Results for “fa_transaction_headers”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_TRANSACTION_HEADERS is the master transaction table in the Oracle Assets (OFA) module. It stores information about every transaction performed within Oracle Assets, including additions, adjustments, transfers, retirements, reclassifications, and capitalizations. Each row represents a single transaction event affecting one asset within a specific asset book, and serves as the parent record that downstream transaction detail tables reference for book, distribution, and history impacts.

In heuristic Data Vault terms, the foreign-key topology classifies this table as hub-leaning. It behaves as a central business-key hub: it carries its own surrogate primary key and is referenced by a wide array of satellite-style detail tables (adjustments, books, distribution history, retirements, and asset history). It also contains self-referencing foreign keys (SOURCE_TRANSACTION_HEADER_ID, MEMBER_TRANSACTION_HEADER_ID), which reflect grouped or mass transactions and support hierarchical transaction modeling.

Key Information Stored

The table is owned by the FA schema and contains 37 documented columns. The surrogate primary key is TRANSACTION_HEADER_ID, enforced by FA_TRANSACTION_HEADERS_PK and further backed by the unique index FA_TRANSACTION_HEADERS_U1, making it the sole documented business-key candidate. The most significant columns include:

• TRANSACTION_HEADER_ID — surrogate primary key uniquely identifying each transaction.
• BOOK_TYPE_CODE — the asset book in which the transaction occurs; references FA_BOOK_CONTROLS.
• ASSET_ID — the asset affected; references FA_ADDITIONS_B.
• TRANSACTION_TYPE_CODE — classifies the transaction (e.g., addition, adjustment, transfer, retirement).
• TRANSACTION_SUBTYPE — further qualifies the transaction type.
• TRANSACTION_DATE_ENTERED and DATE_EFFECTIVE — capture entry and accounting-effective dates.
• TRANSACTION_NAME and TRANSACTION_KEY — descriptive and alternative identifiers for the transaction.
• INVOICE_TRANSACTION_ID — links to FA_INVOICE_TRANSACTIONS for invoice-sourced additions.
• SOURCE_TRANSACTION_HEADER_ID and MEMBER_TRANSACTION_HEADER_ID — self-referencing links for grouped and mass transactions.
• TRX_REFERENCE_ID — reference into FA_TRX_REFERENCES.
• MASS_REFERENCE_ID and MASS_TRANSACTION_ID — identify mass transaction batches.
• EVENT_ID, CALLING_INTERFACE, and AMORTIZATION_START_DATE — support subledger accounting, source interface identification, and amortization.
• Audit and descriptive columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY_CODE, and ATTRIBUTE1–ATTRIBUTE15.

Common Use Cases and Queries

Typical use cases include asset transaction auditing, reconciliation of subledger activity, mass transaction monitoring, and reporting on additions and retirements by book and period. A frequent pattern joins headers to their detail tables using TRANSACTION_HEADER_ID:

• Listing transactions for a book and period: SELECT transaction_header_id, asset_id, transaction_type_code FROM fa_transaction_headers WHERE book_type_code = :book AND date_effective BETWEEN :from_date AND :to_date;
• Joining to FA_ADJUSTMENTS on TRANSACTION_HEADER_ID to retrieve adjustment amounts.
• Following self-references via SOURCE_TRANSACTION_HEADER_ID or MEMBER_TRANSACTION_HEADER_ID to reconstruct mass or grouped transaction hierarchies.
• Joining to FA_BOOKS on TRANSACTION_HEADER_ID_IN or TRANSACTION_HEADER_ID_OUT to trace the before/after financial state of an asset.

Related Objects

The table participates in an extensive relationship network. The most significant related objects include:

• FA_ADJUSTMENTS — references TRANSACTION_HEADER_ID; holds adjustment lines.
• FA_BOOKS — references TRANSACTION_HEADER_ID_IN and TRANSACTION_HEADER_ID_OUT for book-in/out transaction states.
• FA_ASSET_HISTORY and FA_DISTRIBUTION_HISTORY — reference TRANSACTION_HEADER_ID_IN and TRANSACTION_HEADER_ID_OUT for historical tracking.
• FA_RETIREMENTS and FA_TRANSFER_DETAILS — reference TRANSACTION_HEADER_ID_IN/_OUT and TRANSFER_HEADER_ID respectively.
• FA_TRX_REFERENCES — relates via TRX_REFERENCE_ID and back-references through SRC_TRANSACTION_HEADER_ID, DEST_TRANSACTION_HEADER_ID, and MEMBER_TRANSACTION_HEADER_ID.
• FA_BOOK_CONTROLS, FA_ADDITIONS_B, and FA_INVOICE_TRANSACTIONS — referenced by this table for book, asset, and invoice context.
• FA_PARALLEL_WORKERS — references CORP_TRANSACTION_HEADER_ID, TAX_TRANSACTION_HEADER_ID, and TRANSACTION_TYPE_CODE, reflecting mass transaction processing.
• OKL_EXT_FA_LINE_SOURCES_B and PA_PROJECT_ASSET_LINES_ALL — external integration points referencing this table for lease and project asset capitalization.