Search Results fa_cua_mass_update1_pkg




Overview
Explore in AI Chat

Overview

FA_CUA_MASS_UPDATE1_PKG is an Oracle E-Business Suite Release 12.1.1 and 12.2.2 PL/SQL package owned by the APPS schema and classified under Oracle's ETRM repository as an "OTHER" API. It implements the core processing logic for the Oracle Assets Mass Update feature, a utility that allows a single financial adjustment to be applied simultaneously across a large population of assets. Typical uses include reclassifying asset categories, changing depreciation methods or lives, transferring assets between books, and recording mass adjustments or transfers in a single controlled run.

The package is not a public, standalone API. It is the internal engine invoked by the Oracle Assets Mass Update concurrent process, which is in turn driven by batch headers and batch detail rows prepared by the user or by the FA_CUA_MASS_UPDATE forms. Its design is transactional per asset: a driver procedure walks the batch, and for each asset it validates and applies the requested change through the documented Oracle Assets APIs.

Key Procedures and Functions

  • GET_END_DATE — derives or returns the end date used when a mass update changes an asset's life, ensuring the new life is translated into a correct final depreciation date.
  • CALC_LIFE — computes a new asset life value from the mass update parameters.
  • CALC_LIFE_ENDDATE — combines the life calculation with the corresponding end date so that both values remain internally consistent.
  • UPDATE_CATEGORY — applies a category change, together with the associated category defaults (method, life, depreciation convention) for the asset.
  • DO_TRANSFER — performs the mass transfer portion of the update, moving asset cost and related balances between books or accounts.
  • DO_ADJUSTMENT — performs the mass adjustment portion, applying cost or financial adjustments to the selected assets.
  • PROCESS_ASSET — the per-asset worker that evaluates the batch detail row, determines which mass update action applies, and calls the appropriate procedure above.
  • PROCESS_BATCH — iterates the assets belonging to a single mass update batch, invoking PROCESS_ASSET for each and accumulating results.
  • PROC_CONC — the concurrent program entry point; invoked by the Mass Update concurrent request to process one or more batches and report the outcome.

Tables Accessed

The package reads and writes the central Oracle Assets tables through APPS synonyms. Asset master and book data are read from FA_ADDITIONS, FA_BOOKS, and FA_BOOK_CONTROLS. Depreciation context is drawn from FA_DEPRN_PERIODS, FA_CALENDAR_PERIODS, FA_CALENDAR_TYPES, and FA_FISCAL_YEAR. Category and method definitions are validated against FA_CATEGORIES, FA_CATEGORY_BOOKS, and FA_METHODS. Distribution, hierarchy, and lease information is taken from FA_DISTRIBUTION_HISTORY, FA_HIERARCHY_DISTRIBUTIONS, and FA_LEASES. Finally, the batch input and status are managed through FA_MASS_UPDATE_BATCH_HEADERS and FA_MASS_UPDATE_BATCH_DETAILS, with results written back to those detail rows for audit and error reporting.

Usage Notes

FA_CUA_MASS_UPDATE1_PKG is normally invoked indirectly. Oracle Assets submits the Mass Update concurrent program, which calls PROC_CONC to process the identified batch. It depends on FA_API_TYPES and FND_GLOBAL, and it is referenced by FA_CUA_ASSET_APIS and FA_CUA_GAIN_LOSS_EXT_PKG, meaning other CUA-layer packages may delegate to it. Custom code should not call it directly; the supported approach is to populate the mass update batch tables and let the standard concurrent program execute. Because the package writes to FA_BOOKS and FA_DISTRIBUTION_HISTORY, mass updates should be run with appropriate backups and in a controlled period, and the package status should be confirmed as VALID after any patching or upgrade.