Search Results fa_distribution_history

Overview

The FA_DISTRIBUTION_HISTORY table is a core transactional table within the Oracle E-Business Suite Fixed Assets module (OFA). It serves as the definitive historical ledger for tracking the assignment and movement of assets across different cost centers, locations, and employees. Every time an asset's distribution details—such as its assigned-to employee, physical location, or accounting flexfield (code combination)—are changed, a record is created or updated in this table. It provides a complete audit trail of an asset's custodial and accounting history throughout its lifecycle, from capitalization through to retirement, for each asset book.

Key Information Stored

The table's primary key is DISTRIBUTION_ID, which uniquely identifies each distribution record. Its structure captures both the specific assignment details and the transactional context of each change. Critical columns include ASSET_ID and BOOK_TYPE_CODE, which link the distribution to a specific asset in a specific depreciation book. The CODE_COMBINATION_ID stores the accounting flexfield for the asset's cost, while LOCATION_ID and ASSIGNED_TO track physical and custodial assignments. To maintain a precise audit trail, the table references FA_TRANSACTION_HEADERS via TRANSACTION_HEADER_ID_IN (the transaction that created this distribution) and TRANSACTION_HEADER_ID_OUT (the transaction that ended it). The RETIREMENT_ID links the distribution to a retirement event if applicable.

Common Use Cases and Queries

This table is central to asset tracking, audit reporting, and reconciliation. Common use cases include generating reports on asset custody by employee or location, analyzing asset movement history, and supporting period-end close processes by verifying asset cost distributions against the general ledger. A typical query retrieves the current distribution for reporting:

• SELECT dh.asset_id, dh.book_type_code, gc.concatenated_segments, loc.location_code
• FROM fa_distribution_history dh, gl_code_combinations_kfv gc, fa_locations loc
• WHERE dh.code_combination_id = gc.code_combination_id
• AND dh.location_id = loc.location_id
• AND dh.transaction_header_id_out IS NULL -- Current active distribution
• AND dh.asset_id = :p_asset_id;

Another critical pattern is tracing the full distribution history of an asset for audit purposes, joining to FA_TRANSACTION_HEADERS to get transaction dates and types.

Related Objects

FA_DISTRIBUTION_HISTORY has extensive relationships, acting as a hub for asset financial data. It is a direct child of FA_ADDITIONS_B (assets) and FA_BOOKS. Its primary distribution ID is referenced by numerous key transactional tables, most importantly FA_DEPRN_DETAIL (for depreciation calculations) and FA_ADJUSTMENTS (for manual cost adjustments). Other dependent objects include FA_DISTRIBUTION_ACCOUNTS, FA_RETIREMENTS, FA_MASS_EXT_RETIREMENTS, and the capitalized unit tracking tables (CUN_SERIALIZED_UNITS, CUN_NON_SERIALIZED_UNITS). This wide referential integrity underscores its role as the source for an asset's accounting and custodial attributes.