Results for “fa_hr_batch_dist_new_v”

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

Overview

FA_HR_BATCH_DIST_NEW_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the Oracle Assets (OFA) product. It joins the mass-update batch detail table to hierarchy distributions and employee records, allowing the simultaneous review of a mass-update batch and the distribution lines affected by that batch. The view is primarily intended for diagnostics, validation, and operational reporting, exposing the distribution percentage allocated to each affected asset. Because the underlying data originates from mass-update processing rather than journal postings, the view is read-only; no DML is permitted against it.

The view is documented as VALID across both 12.1.1 and 12.2.2 and preserves the same column semantics on both releases. Most columns are direct references to underlying columns; two are derived values computed by the FA_CUA_ASSET_WB_APIS_PKG API package.

Underlying Base Objects

The view is defined over three primary sources in a join condition:

• FA_MASS_UPDATE_BATCH_DETAILS (BD) — supplies the batch identifier, the affected asset, the attribute being recalculated, and the old and new attribute identifiers.
• FA_HIERARCHY_DISTRIBUTIONS (HD) — supplies the distribution identifier, distribution set identifier, distribution line percentage, accounting flexfield, location, and assignee.
• FA_EMPLOYEES (FE) — supplies the employee number and name for the assignee; it is outer-joined on ASSIGNED_TO to allow distributions with no assignee to appear.

The view is filtered on BD.ATTRIBUTE_NAME = 'DISTRIBUTION', and the batch detail is joined to the hierarchy distribution using TO_NUMBER(BD.ATTRIBUTE_NEW_ID) = HD.DIST_SET_ID together with BOOK_TYPE_CODE. The derived columns DEPRN_EXPENSE_ACCOUNT and LOCATION are resolved at runtime by FA_CUA_ASSET_WB_APIS_PKG.GET_ACCOUNT_CODE_NAME and GET_LOCATION_NAME respectively. Employee resolution relies on HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY, which enforces datetrack and security predicates on FA_EMPLOYEES.

Key Columns

• BATCH_ID and ASSET_ID — identify the mass-update batch and the asset it modified.
• ATTRIBUTE_NAME, ATTRIBUTE_OLD_ID, ATTRIBUTE_NEW_ID — the changed attribute (restricted to 'DISTRIBUTION') and the prior and new hierarchy distribution set identifiers.
• DISTRIBUTION_ID and DIST_SET_ID — the specific hierarchy distribution line and the distribution set it belongs to.
• DISTRIBUTION_LINE_PERCENTAGE — the percentage share of the asset's depreciation or hierarchy amount allocated to the distribution line, the column most relevant to the searched term.
• BOOK_TYPE_CODE — the depreciation book in which the distribution is effective.
• CODE_COMBINATION_ID and DEPRN_EXPENSE_ACCOUNT — the accounting flexfield identifier and its resolved concatenated account name.
• LOCATION_ID and LOCATION — the location identifier and its resolved name.
• ASSIGNED_TO, EMPLOYEE_NUMBER, EMPLOYEE_NAME — the assignee identifier and corresponding employee details.

Common Use Cases and Queries

Typical use cases include verifying that distribution percentages sum as expected after a mass update, tracing which assets were reallocated to which accounts, and confirming employee assignment of distribution lines.

Example: review all distribution lines for a batch.

SELECT asset_id, dist_set_id, distribution_line_percentage, deprn_expense_account, location, employee_name FROM fa_hr_batch_dist_new_v WHERE batch_id = :p_batch_id ORDER BY asset_id, distribution_id;

Example: identify lines whose percentages do not reconcile to a full allocation within a book.

SELECT batch_id, book_type_code, asset_id, SUM(distribution_line_percentage) FROM fa_hr_batch_dist_new_v WHERE book_type_code = :p_book GROUP BY batch_id, book_type_code, asset_id HAVING SUM(distribution_line_percentage) <> 100;

Example: list all distributions assigned to a specific employee.

SELECT batch_id, asset_id, distribution_line_percentage, deprn_expense_account FROM fa_hr_batch_dist_new_v WHERE assigned_to = :p_employee_id;

Because the view includes no posting, journal, or period context, it should be used for batch administration and validation rather than for financial statement reporting, where the depreciation and distribution hierarchies are queried directly.