Search Results fa_trx_references




Overview
Explore in AI Chat

Overview

The FA_TRX_REFERENCES table is a core transactional data object within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). Its primary role is to maintain a detailed audit trail for inter-asset transactions, which are complex asset movements such as transfers, splits, and merges. When an asset transaction involves multiple source and destination assets, this table creates the necessary linkages between the related transaction headers and asset records. It serves as a central reference point, ensuring data integrity and enabling the reconstruction of transaction histories for reporting, reconciliation, and audit purposes across versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its foreign key relationships, which point to the primary transactional entities in Fixed Assets. The key column is the system-generated primary key, TRX_REFERENCE_ID. The table's purpose is to store the relationships between transaction components, which is reflected in its critical foreign key columns. These include BOOK_TYPE_CODE to identify the asset book, and pairs of columns that link source, destination, and member assets to their respective master records: SRC_ASSET_ID, DEST_ASSET_ID, and MEMBER_ASSET_ID reference the FA_ADDITIONS_B table, while SRC_TRANSACTION_HEADER_ID, DEST_TRANSACTION_HEADER_ID, and MEMBER_TRANSACTION_HEADER_ID reference the FA_TRANSACTION_HEADERS table. The INVOICE_TRANSACTION_ID column links to the FA_INVOICE_TRANSACTIONS table, connecting the asset transaction to its originating invoice line.

Common Use Cases and Queries

This table is essential for troubleshooting and reporting on complex asset movements. A common use case is tracing the complete lineage of a split or merged asset. For instance, to find all assets created from a specific source asset transaction, one would query FA_TRX_REFERENCES using the SRC_TRANSACTION_HEADER_ID. Conversely, to find the source of a destination asset, the query would use the DEST_TRANSACTION_HEADER_ID. It is also critical for reconciliation reports that must validate that the cost basis from source assets correctly transfers to destination assets in a merge operation. Sample SQL often involves joining FA_TRX_REFERENCES to FA_TRANSACTION_HEADERS and FA_ADDITIONS_B multiple times, using table aliases to distinguish between source and destination entities.

Related Objects

The FA_TRX_REFERENCES table sits at the intersection of major Fixed Assets tables, as documented by its foreign key constraints. It references the following objects:

  • FA_BOOK_CONTROLS via BOOK_TYPE_CODE
  • FA_ADDITIONS_B via SRC_ASSET_ID, DEST_ASSET_ID, and MEMBER_ASSET_ID
  • FA_TRANSACTION_HEADERS via SRC_TRANSACTION_HEADER_ID, DEST_TRANSACTION_HEADER_ID, and MEMBER_TRANSACTION_HEADER_ID
  • FA_INVOICE_TRANSACTIONS via INVOICE_TRANSACTION_ID

Furthermore, the FA_TRANSACTION_HEADERS table holds a reciprocal foreign key relationship, referencing FA_TRX_REFERENCES.TRX_REFERENCE_ID. This bidirectional link solidifies the table's role as the authoritative source for inter-transaction relationships within the asset lifecycle.