Search Results fa_mass_external_transfers




Overview
Explore in AI Chat

Overview

FA_MASS_EXTERNAL_TRANSFERS is the Assets (OFA) interface table used to stage and process mass external transfer transactions in Oracle EBS 12.1.1 and 12.2.2. An external transfer moves a capitalized asset, or a portion of its units, from one employee, location, or distribution combination to another without creating a new asset. Rather than keying these movements individually, users load many transfer lines into this interface table and then run the Mass External Transfer process, which validates the rows and creates the corresponding records in the transaction tables. The table therefore sits in the inbound integration layer of the Oracle Assets subledger, feeding the standard transaction generation engine.

Based on the mined foreign key structure the object is classified as standalone under the heuristic Data Vault model. This means it carries no outbound foreign key dependencies to other hubs in the documented schema; it behaves as an isolated staging entity rather than a hub, link, or satellite. Rows are keyed by the surrogate primary key MASS_EXTERNAL_TRANSFER_ID, enforced by the unique index FA_MASS_EXTERNAL_TRANSFERS_U1.

Key Information Stored

The table contains 81 documented columns. The most significant include:

Common Use Cases and Queries

The table is queried during interface troubleshooting, batch reconciliation, and pre-process validation. A typical diagnostic query retrieves all rows for a given batch:

  • SELECT MASS_EXTERNAL_TRANSFER_ID, FROM_ASSET_ID, TO_ASSET_ID, BOOK_TYPE_CODE, TRANSACTION_STATUS FROM FA_MASS_EXTERNAL_TRANSFERS WHERE BATCH_NAME = :batch;
  • Counting rows by status to confirm a batch is ready: SELECT TRANSACTION_STATUS, COUNT(*) FROM FA_MASS_EXTERNAL_TRANSFERS GROUP BY TRANSACTION_STATUS;
  • Auditing recent loads: SELECT * FROM FA_MASS_EXTERNAL_TRANSFERS WHERE CREATION_DATE > SYSDATE - 1;

Common practical scenarios include verifying that source and destination employee/location/account combinations are populated before submission, reconciling interface rows against generated transaction records, and extracting transfer history for audit or migration reporting.

Related Objects

The interface table interoperates with the core Oracle Assets transaction schema. The most significant related objects are:

  • FA_TRANSACTIONS — the destination table where validated external transfers are written.
  • FA_ADDITIONS — holds the asset definitions identified by FROM_ASSET_ID and TO_ASSET_ID.
  • FA_BOOKS — supplies the book referenced by BOOK_TYPE_CODE.
  • FA_DISTRIBUTION_HISTORY — records the assignment history behind FROM_DISTRIBUTION_ID and TO_DISTRIBUTION_ID.
  • FA_LOCATIONS — resolves the FROM_LOCATION_ID / TO_LOCATION_ID values.
  • PER_ALL_PEOPLE_F / PER_EMPLOYEES — resolve the FROM_EMPLOYEE_ID / TO_EMPLOYEE_ID assignments.
  • GL_CODE_COMBINATIONS — resolves the FROM_GL_CCID / TO_GL_CCID account combinations.

These relationships are referenced at processing time rather than enforced through declared foreign keys, consistent with the table's standalone classification.