Search Results fa_mass_external_transfers_v




Overview
Explore in AI Chat

Overview

FA_MASS_EXTERNAL_TRANSFERS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OFA (Oracle Assets) product family. It exposes the contents of the FA_MASS_EXTERNAL_TRANSFERS interface table enriched with descriptive attributes drawn from the asset master, book, asset history, distribution history, and HR person tables. The view is the primary read-only surface used to inspect externally sourced mass transfer transactions prior to, during, and after their posting into Oracle Assets.

In Oracle EBS 12.1.1 and 12.2.2 the object carries a status of VALID. Its principal role is to support reconciliation and audit reporting for mass transfers initiated outside the standard Assets transfer forms — for example, transfers imported through interface programs or inter-company asset movements captured via external systems. The view resolves surrogate identifiers (FROM_ASSET_ID, TO_ASSET_ID) into human-readable ASSET_NUMBER values, which is precisely why searches involving "to_asset_number" resolve to this object.

Underlying Base Objects

The view is defined over FA_MASS_EXTERNAL_TRANSFERS (the driving table, aliased EXT) joined to several supporting objects. The FROM_ASSET_ID links inward-joined to FA_ADDITIONS (AD1), FA_BOOKS (BK), and FA_ASSET_HISTORY (AH); the TO_ASSET_ID outer-joins to FA_ADDITIONS (AD2). Distribution information is outer-joined through FA_DISTRIBUTION_HISTORY (DH) on FROM_DISTRIBUTION_ID. Employee attributes are outer-joined via PER_PEOPLE_X (PX2) and PER_PERIODS_OF_SERVICE (PS2) on TO_EMPLOYEE_ID.

Documented referenced base objects also include HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages, which provide the security and name-resolution logic underlying PER_PEOPLE_X. The BOOK_TYPE_CODE predicate against FA_BOOKS and the DATE_INEFFECTIVE IS NULL filters on FA_BOOKS and FA_ASSET_HISTORY ensure only currently effective rows contribute to the result set.

Key Columns

Common Use Cases and Queries

The view is typically used to confirm that a mass external transfer posted to the intended asset, to reconcile transfer amounts against the book, and to trace custodianship changes. A common query filtering on the destination asset number follows:

  • SELECT mass_external_transfer_id, batch_name, from_asset_number, to_asset_number, transaction_type, transfer_units, transfer_amount FROM fa_mass_external_transfers_v WHERE to_asset_number = :p_to_asset_number;
  • SELECT batch_name, transaction_status, COUNT(*) FROM fa_mass_external_transfers_v WHERE book_type_code = :p_book GROUP BY batch_name, transaction_status;
  • SELECT to_asset_number, to_employee_name, to_employee_number, transfer_amount FROM fa_mass_external_transfers_v WHERE batch_name = :p_batch ORDER BY to_asset_number;

Because the view filters on effective book and asset history rows, reports should be run against the current period to avoid stale or superseded records.