Results for “fa_distribution_hist_web_v”

30 results




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

Overview

FA_DISTRIBUTION_HIST_WEB_V is an APPS-owned reporting view in the Oracle E-Business Suite OFA (Oracle Assets) module. It exposes historical asset distribution information — the record of how asset units or amounts have been assigned to employees, locations, and accounts over time — in a form suited to web-based inquiry and reporting. The view is documented as VALID on both 12.1.1 and 12.2.2 and carries the description "Historical distribution information."

Its defining characteristic is the filter DH.DATE_INEFFECTIVE IS NULL, which restricts the output to currently effective distribution rows from FA_DISTRIBUTION_HISTORY. In this respect the view acts as an "active assignments" projection of the distribution history table, joining each row to the employee assigned, the concatenated accounting flexfield value, and the concatenated location flexfield value. Because it joins key flexfield (KFV) views, the view exposes readable concatenated segments rather than raw ID values, which makes it a preferred source for ad hoc queries, Oracle Discoverer/BI Publisher reports, and downstream integrations that need distribution detail without resolving flexfield IDs themselves.

Underlying Base Objects

The view is defined over the following documented base objects:

The join chain therefore links distribution history to book controls (for the chart of accounts), to the accounting and location KFV views (for readable segment values), and to person data (for assignment detail), with the employee join expressed as an outer join so distribution rows are not dropped when assignment data is absent.

Key Columns

Common Use Cases and Queries

The view is commonly used to answer "who has what, where, and on which account" for currently effective asset distributions. Typical scenarios include reconciliation of asset assignments to employees, review of location-level asset holdings, and extraction of distribution data into reporting or integration pipelines.

Sample query returning current distributions for a book:

  • SELECT asset_id, book_type_code, assigned_to_name, location_concatenated, accounting_concatenated, units_assigned FROM apps.fa_distribution_hist_web_v WHERE book_type_code = :book AND asset_id = :asset_id ORDER BY date_effective;

Sample query aggregating units by location:

  • SELECT location_concatenated, SUM(units_assigned) total_units FROM apps.fa_distribution_hist_web_v WHERE book_type_code = :book GROUP BY location_concatenated ORDER BY total_units DESC;

Because the view already resolves the KFV concatenated segments and employee names, it eliminates the need to join FA_LOCATIONS_KFV, GL_CODE_COMBINATIONS_KFV, and PER_PEOPLE_X in ad hoc code. Note that HR security packages participate in the PER_PEOPLE_X view, so person attributes are subject to the querying user's HR security profile. The view returns only rows with DATE_INEFFECTIVE IS NULL; historical, expired distributions must be queried directly from FA_DISTRIBUTION_HISTORY.