Search Results do_mass_transfer

Overview

APPS.FA_MASSTFR_PKG is a PL/SQL package in the Oracle E-Business Suite Fixed Assets module that supports the mass transfer of assets between accounting entities, books, and locations. The package encapsulates the core processing logic invoked by the Mass Transfer concurrent program (and its related request set), which moves large volumes of assets in a single operation rather than requiring users to transfer assets individually through the Fixed Assets forms.

The source header shows a relatively early revision of the specification (120.1, dated 2002), which is consistent with the package's long-standing role in the Fixed Assets transfer architecture. Because mass transfers frequently involve thousands of assets and can be long-running, the package is designed for parallel processing: the caller divides the work into multiple concurrent requests, and each request processes a subset of the assets identified by the mass transfer definition. The package reports success and failure counts back to the caller so the concurrent manager can summarize the outcome.

Key Procedures and Functions

The specification exposes a single documented procedure:

• DO_MASS_TRANSFER — The worker procedure that performs the actual transfer of assets for one slice of a mass transfer run. It accepts the mass transfer identifier, the parent request identifier, the total number of requests in the parallel run, and the current request number. It also receives an in-out high-water mark for the maximum asset identifier (used to partition the asset population across parallel workers), and returns success count, failure count, and a return status. The return status allows callers and the concurrent program to detect whether the transfer completed, completed with errors, or failed outright. The procedure signature is the only documented API entry point; all other logic is internal to the package body and is not part of the published interface.

No standalone functions are documented. Any validation, code combination derivation, or distribution history maintenance is performed within DO_MASS_TRANSFER or private package-level routines.

Tables Accessed

Per the ETRM metadata, the package operates against the following tables through APPS synonyms:

• FA_MASS_TRANSFERS — The driving table holding the mass transfer definition and header information for the run.
• FA_ADDITIONS_B — The base asset table, read to identify the assets eligible for transfer and updated as the transfer is applied.
• FA_BOOKS — The asset book balances, which must be adjusted for the new entity, location, or book assignment.
• FA_ASSET_HIERARCHY — Tracks parent/child relationships among assets so hierarchy-dependent assets remain consistent after transfer.
• FA_DISTRIBUTION_HISTORY — Records the assignment history, preserving an audit trail of prior and new distribution.
• PER_PERIODS_OF_SERVICE — Used to align transfer effects with the periods of service during which the assets were held.
• GL_CODE_COMBINATIONS — Supplies the accounting flexfield combinations for the destination entity and distributions.
• PLITBLM — The standard Oracle Applications temporary table used for bulk operations and parallel processing.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, FA_MASSTFR_PKG is not intended for direct invocation by end users. It is called by the Fixed Assets Mass Transfer concurrent program, which is submitted with a mass transfer definition ID and a number of parallel workers. Each worker invokes DO_MASS_TRANSFER with its own request number, the shared total request count, and a shared maximum asset ID cursor that is advanced through the in-out parameter, so that workers do not process overlapping assets.

Custom code should avoid calling DO_MASS_TRANSFER directly; the supported integration point for asset transfers is the Fixed Assets open interface and the standard concurrent program. Because the ETRM classification for this package is OTHER and it is referenced by zero other packages, it should be treated as an internal implementation object whose signature may change between releases. Customers migrating from 12.1.1 to 12.2.2 should verify that any custom mass-transfer extensions rely on the concurrent program interface rather than on this package's private structure.