Results for “fa_distribution_history”

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

Overview

FA_DISTRIBUTION_HISTORY is the Oracle Assets (OFA) table that stores the employee, location, and Accounting Flexfield (general ledger account) assignments applied to each asset. Every time an asset is assigned, transferred, reclassified, or retired, the distribution of that asset across accounting and physical dimensions is recorded in this table. The table resides in the FA schema and is a core component of the Oracle E-Business Suite 12.1.1 and 12.2.2 data model, functioning as the authoritative source for which depreciation expense accounts, cost centers, and locations an asset occupies during each effective period.

Because FA_DISTRIBUTION_HISTORY preserves both effective and ineffective dates, it provides a full audit trail of asset distribution over time rather than a single current-state snapshot. Depreciation, adjustments, transfers, capital budgets, and deferred depreciation processes all reference specific distribution records when allocating amounts.

Heuristically, and based on the foreign key structure, this table leans toward a hub classification in a Data Vault model. Its surrogate primary key, DISTRIBUTION_ID, serves as a durable business key referenced by a large number of satellite-style fact and detail tables. A Data Vault practitioner would typically model FA_DISTRIBUTION_HISTORY as a hub, with the related FA_DEPRN_DETAIL, FA_ADJUSTMENTS, and FA_BOOKS relationships represented as links or satellites.

Key Information Stored

The surrogate primary key is DISTRIBUTION_ID, enforced by the FA_DISTRIBUTION_HISTORY_PK constraint and mirrored by the unique index FA_DISTRIBUTION_HISTORY_U1. This identifier is the business-key candidate of the table and is the column through which the majority of dependent Objects join back.

• DISTRIBUTION_ID – Surrogate primary key and unique business-key candidate; referenced by depreciation, adjustment, transfer, and retirement detail tables.
• ASSET_ID – Foreign key to FA_ADDITIONS_B; identifies the asset to which the distribution belongs.
• BOOK_TYPE_CODE – Foreign key to FA_BOOK_CONTROLS; identifies the depreciation book (for example, a corporate book or tax book) to which the distribution applies.
• CODE_COMBINATION_ID – Foreign key to GL_CODE_COMBINATIONS; the Accounting Flexfield combination used for the asset's distribution.
• LOCATION_ID – Foreign key to FA_LOCATIONS; the physical location assigned to the asset.
• UNITS_ASSIGNED – Number of units assigned to the distribution, used for multi-unit assets.
• DATE_EFFECTIVE and DATE_INEFFECTIVE – Bound the active period of the distribution, enabling historical reconstruction.
• TRANSACTION_HEADER_ID_IN and TRANSACTION_HEADER_ID_OUT – Foreign keys to FA_TRANSACTION_HEADERS; record the transaction that established the distribution (in) and the one that ended it (out).
• TRANSACTION_UNITS – Units moved during the associated transaction.
• RETIREMENT_ID – Foreign key to FA_RETIREMENTS; appears when the distribution is linked to a retirement.
• ASSIGNED_TO – Employee or party to whom the asset is assigned.
• CAPITAL_ADJ_ACCOUNT_CCID and GENERAL_FUND_ACCOUNT_CCID – Alternate Accounting Flexfield combinations used for capital adjustment and general fund accounting.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN – Standard Oracle audit columns.

Common Use Cases and Queries

The table supports a wide range of operational and reporting scenarios: reconstructing the current distribution of an asset, tracing the history of account assignments for audit and reconciliation, and joining to depreciation results to allocate expense by cost center. A typical query retrieves active distributions for a book and asset:

• SELECT asset_id, book_type_code, code_combination_id, location_id, date_effective, date_ineffective FROM fa_distribution_history WHERE date_ineffective IS NULL;
• Join to FA_DEPRN_DETAIL on DISTRIBUTION_ID to allocate period depreciation to the correct Accounting Flexfield.
• Join to FA_ADJUSTMENTS to determine which distribution an adjustment affected.
• Join to FA_TRANSFER_DETAILS to review transfers between employees, locations, or accounts.
• Join to FA_ADDITIONS_B and FA_BOOK_CONTROLS for asset-level and book-level reporting.

Common reporting needs include account-level depreciation summaries, cost-center rollups, and audit reports showing every distribution change recorded against an asset.

Related Objects

The most significant related objects, based on the documented foreign key relationships, are:

• FA_ADDITIONS_B via FA_DISTRIBUTION_HISTORY.ASSET_ID – the asset master.
• FA_BOOK_CONTROLS and FA_BOOKS via BOOK_TYPE_CODE – depreciation book definitions.
• GL_CODE_COMBINATIONS via CODE_COMBINATION_ID – general ledger account validation.
• FA_LOCATIONS via LOCATION_ID – asset location definitions.
• FA_TRANSACTION_HEADERS via TRANSACTION_HEADER_ID_IN and TRANSACTION_HEADER_ID_OUT – bounding transactions.
• FA_RETIREMENTS via RETIREMENT_ID – retirement events.
• FA_DEPRN_DETAIL and FA_DEFERRED_DEPRN via DISTRIBUTION_ID – depreciation expense allocation.
• FA_ADJUSTMENTS and FA_TRANSFER_DETAILS via DISTRIBUTION_ID – adjustments and inter-distribution transfers.
• FA_DISTRIBUTION_ACCOUNTS via DISTRIBUTION_ID – the accounts associated with the distribution.
• Additional dependent tables such as FA_CAPITAL_BUDGET, FA_MASS_EXT_RETIREMENTS, and IA_REQUEST_DETAILS (FROM_ and TO_ DISTRIBUTION_ID) reference DISTRIBUTION_ID for budgeting and transfer-request processing.