Search Results fa_transfer_details




Overview
Explore in AI Chat

Overview

The FA_TRANSFER_DETAILS table is a core data object within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). It functions as a critical audit and reconciliation table by permanently recording the historical relationship between active asset records and their associated distribution history. Specifically, it links a row in the FA_BOOKS table, which represents an asset's current financial status in a particular depreciation book, with the corresponding row in the FA_DISTRIBUTION_HISTORY table, which tracks the assignment of asset cost to specific locations or accounts over time. This linkage is essential for maintaining data integrity, supporting audit trails, and enabling detailed historical reporting on asset transfers and cost allocations.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which establish its role as a junction table. The primary key is a composite of TRANSFER_HEADER_ID and DISTRIBUTION_ID, ensuring a unique record for each distribution event linked to a transfer transaction. The key columns and their relationships are:

  • TRANSFER_HEADER_ID: References FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID, linking the detail record to the overarching asset transaction (e.g., a transfer, addition, or adjustment).
  • DISTRIBUTION_ID: References FA_DISTRIBUTION_HISTORY.DISTRIBUTION_ID, linking to the specific historical distribution line being associated.
  • BOOK_HEADER_ID: References FA_BOOKS.BOOK_HEADER_ID, linking to the active asset book record that is related to the historical distribution.

This schema ensures that for any active asset in FA_BOOKS, one can trace back through FA_TRANSFER_DETAILS to find all distribution history entries that contributed to its current cost basis.

Common Use Cases and Queries

The primary use case is auditing the lineage of an asset's cost and location. It is crucial for answering questions about how an asset's current book value was derived from past transactions. A common reporting requirement is to generate a history of transfers for a specific asset, showing the link between its current book record and all prior distributions. A sample query pattern to retrieve this information would join the key related tables:

  • SELECT fth.transaction_header_id, fb.asset_id, fdh.distribution_id, fdh.location_id
    FROM fa_transfer_details ftd,
    fa_transaction_headers fth,
    fa_books fb,
    fa_distribution_history fdh
    WHERE ftd.transfer_header_id = fth.transaction_header_id
    AND ftd.book_header_id = fb.book_header_id
    AND ftd.distribution_id = fdh.distribution_id
    AND fb.asset_id = :p_asset_id;

This table is also integral to internal Fixed Assets processes when rolling back transactions or reconciling data, as it preserves the necessary relationships to reconstruct asset history accurately.

Related Objects

FA_TRANSFER_DETAILS is centrally connected to several other fundamental Fixed Assets tables, as defined by its foreign key constraints:

  • FA_TRANSACTION_HEADERS: Provides the transactional context (date, type) for the linkage.
  • FA_BOOKS: Represents the active asset book record that is the target of the relationship.
  • FA_DISTRIBUTION_HISTORY: Represents the source historical distribution record being linked.

Understanding FA_TRANSFER_DETAILS is therefore essential when working with any reporting or data extraction involving asset cost history, transfer audits, or the reconciliation between the FA_BOOKS and FA_DISTRIBUTION_HISTORY tables.