Search Results fa_hierarchy_distributions




Overview
Explore in AI Chat

Overview

FA_HIERARCHY_DISTRIBUTIONS is a table in the Oracle Assets (OFA) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores distribution sets that are attached to a specific hierarchy node, where each distribution set defines a combination of an expense account, a location, and an employee. Because these assignments are held at the node level, they may be inherited by downstream nodes in the asset hierarchy, allowing an organization to define default accounting, physical location, and assignment data once and propagate it through subordinate levels of the hierarchy. The table resides in the FA schema and is documented as VALID in the ETRM 12.2.2 repository with a physical structure of twelve columns and a single unique index on DISTRIBUTION_ID.

From a Data Vault modeling perspective, the FK relationship metadata classifies this object heuristically as standalone. This suggests that FA_HIERARCHY_DISTRIBUTIONS is best modeled as a satellite or independent descriptive entity rather than as a central hub or link, since its only documented foreign key points outward to FA_DISTRIBUTION_SETS and no other table references it directly. Modeling it as a standalone satellite of the hierarchy node aligns with its role of carrying distribution attribute context.

Key Information Stored

The table contains twelve documented columns. The most significant are the following:

  • DISTRIBUTION_ID — the surrogate primary key and the column named in the unique index FA_HIERARCHY_DISTRIBUTIONS_U1. This is the principal unique identifier and the strongest business-key candidate for the row.
  • DIST_SET_ID — the foreign key to FA_DISTRIBUTION_SETS, identifying which distribution set is associated with the hierarchy node. This is the core linkage that makes the row meaningful.
  • BOOK_TYPE_CODE — the asset book in which the distribution applies, allowing different distribution behavior across corporate, tax, and other books.
  • DISTRIBUTION_LINE_PERCENTAGE — the percentage allocation applied to the distribution line when a set is inherited or applied across multiple targets.
  • CODE_COMBINATION_ID — the expense account combination (Accounting Flexfield) used by the distribution.
  • LOCATION_ID — the location associated with the hierarchy node's distribution.
  • ASSIGNED_TO — the employee to whom the distribution assets are assigned.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns, recording who created and last modified the row and when.

The identification of DISTRIBUTION_ID as the unique key is documented, while BOOK_TYPE_CODE and DIST_SET_ID behave as meaningful business attributes rather than enforced unique keys.

Common Use Cases and Queries

This table is typically queried to determine which expense account, location, and employee defaults are attached to a given hierarchy node, or to trace how a distribution set is inherited across the hierarchy. A common query joins the table to FA_DISTRIBUTION_SETS on DIST_SET_ID to retrieve the set name and details:

  • Inheritance auditing: list all nodes inheriting a specific distribution set and the percentage applied, filtering by DISTRIBUTION_LINE_PERCENTAGE and BOOK_TYPE_CODE.
  • Account validation: join to GL_CODE_COMBINATIONS on CODE_COMBINATION_ID to verify that assigned expense accounts are valid and enabled.
  • Assignment reporting: join to PER_ALL_PEOPLE_F via ASSIGNED_TO, and to HR_LOCATIONS_ALL via LOCATION_ID, to produce location and employee assignment reports.
  • Book-specific distribution analysis: group by BOOK_TYPE_CODE to compare how distributions differ between books.

A representative pattern is: SELECT d.DISTRIBUTION_ID, d.DIST_SET_ID, s.DISTRIBUTION_SET_NAME, d.CODE_COMBINATION_ID, d.LOCATION_ID, d.ASSIGNED_TO FROM FA_HIERARCHY_DISTRIBUTIONS d JOIN FA_DISTRIBUTION_SETS s ON s.DIST_SET_ID = d.DIST_SET_ID WHERE d.BOOK_TYPE_CODE = :book.

Related Objects

The following objects are the most significant references to or dependencies of FA_HIERARCHY_DISTRIBUTIONS:

  • FA_DISTRIBUTION_SETS — referenced through FA_HIERARCHY_DISTRIBUTIONS.DIST_SET_ID; the parent definition of the distribution set itself.
  • FA_HIERARCHY — the hierarchy structure whose node context drives inheritance of these distributions.
  • FA_ADDITIONS — asset records that inherit location, employee, and account defaults from hierarchy distributions.
  • FA_BOOK_CONTROLS — defines the asset books referenced by BOOK_TYPE_CODE.
  • GL_CODE_COMBINATIONS — resolves CODE_COMBINATION_ID to the expense account flexfield.
  • HR_LOCATIONS_ALL and PER_ALL_PEOPLE_F — resolve LOCATION_ID and ASSIGNED_TO to physical locations and employees.

Because no other table maintains a documented foreign key back to FA_HIERARCHY_DISTRIBUTIONS, it functions as a dependent child of FA_DISTRIBUTION_SETS and is consumed by hierarchy-driven asset processing rather than acting as a referenced parent itself.