Search Results fa_hierarchy_distributions_u1

Overview

FA.FA_HIERARCHY_DISTRIBUTIONS is a transaction data table within the Oracle E-Business Suite Fixed Assets (FA) module. It stores the individual distribution lines that make up a distribution set, allowing a single accounting allocation to be shared across multiple general ledger code combinations, depreciation locations, or assigned employees. Each record represents one weighted component of a parent distribution set, expressed as a percentage of the total allocation. This design enables organizations to model cost-sharing arrangements where a corporate asset's expenses must be spread across several departments, cost centers, or reporting entities.

From a Data Vault modeling perspective, the mined dependency classification treats this object as standalone. It does not reference any database object through a documented foreign key, although its DIST_SET_ID column logically associates it with FA_DISTRIBUTION_SETS. Given its single parent-like dependency and its store of descriptive allocation attributes, this table would most naturally be modeled as a satellite attached to the distribution set hub, with DISTRIBUTION_ID serving as the row-level unique key.

The table resides in the APPS_TS_TX_DATA tablespace in the FA schema and is registered under the FND Design Data application OFA. It carries a status of VALID in the ETRM metadata for release 12.1.1 and 12.2.2.

Key Information Stored

The most significant columns in FA_HIERARCHY_DISTRIBUTIONS are:

• DISTRIBUTION_ID — the surrogate primary key for each distribution line. It is the single column of the unique index FA_HIERARCHY_DISTRIBUTIONS_U1 on tablespace APPS_TS_TX_IDX, and is the only documented business-key candidate for row uniqueness.
• DIST_SET_ID — identifies the parent distribution set to which this line belongs; the subject of the nonunique index FA_HIERARCHY_DISTRIBUTIONS_N1.
• DISTRIBUTION_LINE_PERCENTAGE — the share of the total allocation assigned to this line, typically summing to 100 percent across all lines in a set.
• BOOK_TYPE_CODE — the depreciation book to which the distribution applies, a 15-character code linking the line to a specific corporate or tax book.
• CODE_COMBINATION_ID — the General Ledger account combination that receives the distributed expense.
• LOCATION_ID — the FA location or location address associated with the distribution line.
• ASSIGNED_TO — the employee or party to whom the distribution is assigned, commonly used for expense reporting or accountability.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns capturing who created and last modified the record and when.

Together these columns define the accounting, book, location, and ownership context of each proportional allocation within a distribution set.

Common Use Cases and Queries

Typical usage centers on reporting and validating how an allocation is split. A common query retrieves all lines for a given set:

• SELECT distribution_id, distribution_line_percentage, code_combination_id FROM fa.fa_hierarchy_distributions WHERE dist_set_id = :p_set_id;
• Aggregate validation: SELECT dist_set_id, SUM(distribution_line_percentage) FROM fa.fa_hierarchy_distributions GROUP BY dist_set_id;
• Book-specific reporting: filtering by BOOK_TYPE_CODE to reconcile distributions to a particular depreciation book.
• Account analysis: joining CODE_COMBINATION_ID to GL code combinations to report distributed expense by account.
• Employee allocation: grouping by ASSIGNED_TO to show how costs are apportioned to individuals.

These patterns support month-end reconciliation, allocation audits, and migration checks confirming that line percentages total 100 percent per set.

Related Objects

The most significant related objects are:

• FA.FA_DISTRIBUTION_SETS — the parent set referenced by DIST_SET_ID; the primary association for this table.
• FA.FA_DISTRIBUTION_SET_LINES — companion line detail for distribution sets.
• GL.GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID to resolve account descriptions.
• FA.FA_LOCATIONS — joined on LOCATION_ID for location detail.
• FA.FA_BOOK_CONTROLS — related through BOOK_TYPE_CODE for book definition.
• FA.FA_ADDITIONS and FA.FA_ADJUSTMENTS — asset transactions that may draw on distribution sets during mass additions or transfers.
• APPS.FA_HIERARCHY_DISTRIBUTIONS — the APPS synonym through which application code and reports typically access the table.