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:
- FA_DISTRIBUTION_HISTORY (synonym) — the driving table, aliased DH; supplies asset distribution rows, unit assignments, effective/ineffective dates, transaction references, and retirement references.
- FA_BOOK_CONTROLS (synonym) — aliased BC; joined on BOOK_TYPE_CODE and used to supply ACCOUNTING_FLEX_STRUCTURE for the accounting flexfield join.
- FA_LOCATIONS_KFV (view) — aliased LOC; provides CONCATENATED_SEGMENTS for the location flexfield.
- FA_SYSTEM_CONTROLS (synonym) — referenced in the FROM clause as part of the join graph.
- GL_CODE_COMBINATIONS_KFV (view) — aliased GLCC; provides CONCATENATED_SEGMENTS for the accounting flexfield, joined on CODE_COMBINATION_ID and CHART_OF_ACCOUNTS_ID.
- PER_PEOPLE_X (view) — aliased P; supplies ASSIGNED_TO_NUMBER, ASSIGNED_TO_NAME, EMPLOYEE_NUMBER, and FULL_NAME via an outer join on PERSON_ID.
- PER_PERIODS_OF_SERVICE (synonym) — aliased S; outer-joined on PERSON_ID.
- HR_GENERAL, HR_PERSON_NAME, HR_SECURITY (packages) — referenced by the PER_PEOPLE_X view to enforce person-name formatting and HR security.
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
- ROW_ID — the ROWID of the underlying FA_DISTRIBUTION_HISTORY row; useful for direct row identification.
- DISTRIBUTION_ID — primary identifier for the distribution record.
- BOOK_TYPE_CODE — the asset book to which the distribution belongs.
- ASSET_ID — the asset being distributed.
- UNITS_ASSIGNED / TRANSACTION_UNITS — units assigned to the distribution and units involved in the associated transaction.
- DATE_EFFECTIVE / DATE_INEFFECTIVE — the effective date range of the assignment; DATE_INEFFECTIVE is null for rows returned by this view.
- CODE_COMBINATION_ID / LOCATION_ID — foreign keys to the accounting and location flexfields.
- ASSIGNED_TO / ASSIGNED_TO_NUMBER / ASSIGNED_TO_NAME / EMPLOYEE_NUMBER / FULL_NAME — employee identifiers and names derived from PER_PEOPLE_X.
- ACCT_CONC_SEGMENTS / ACCOUNTING_CONCATENATED — concatenated accounting flexfield segments from GL_CODE_COMBINATIONS_KFV.
- LOC_CONC_SEGMENTS / LOCATION_CONCATENATED — concatenated location flexfield segments from FA_LOCATIONS_KFV.
- TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT / RETIREMENT_ID — in/out transaction and retirement references that explain how the assignment originated or ended.
- LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — standard audit 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.
-
Historical distribution information
APPS.FA_DISTRIBUTION_HIST_WEB_V·↳ FA_BOOK_CONTROLS·↳ FA_DISTRIBUTION_HISTORY·↳ FA_LOCATIONS_KFV·Explore OFA module →
-
Historical distribution information
APPS.FA_DISTRIBUTION_HIST_WEB_V·↳ FA_BOOK_CONTROLS·↳ FA_DISTRIBUTION_HISTORY·↳ FA_LOCATIONS_KFV·Explore OFA module →
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
VIEW: APPS.FA_LOCATIONS_KFV 12.2.2
-
VIEW: APPS.FA_LOCATIONS_KFV 12.1.1
-
VIEW: APPS.PER_PEOPLE_X 12.2.2
-
VIEW: APPS.PER_PEOPLE_X 12.1.1
-
eTRM - OFA Tables and Views 12.1.1
-
eTRM - OFA Tables and Views 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
USSGL transaction codes
-
eTRM - OFA Tables and Views 12.1.1
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
USSGL transaction codes
-
eTRM - OFA Tables and Views 12.2.2
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person