Search Results do_mass_change

Overview

FA_MASSCHG_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It supports the Mass Changes feature of Oracle Assets, which allows a user to modify a common attribute across a large population of assets in a single, controlled operation rather than editing each asset individually. Typical mass changes include reclassifying assets between categories, adjusting depreciation attributes, and other book-level or asset-level updates that must be propagated consistently.

The package encapsulates the validation and update logic required to apply a mass change and record the resulting asset transactions. Its status is VALID, and in the ETRM repository it is classified as an "OTHER" API rather than a formally published open interface. The package body resolves references through the SYS.STANDARD package, and it is referenced by itself and by APPS-level callers. In the 12.2.2 metadata, FA_MASSCHG_PKG is referenced by zero other packages, indicating it sits near the top of the call stack rather than serving as a shared utility for other PL/SQL modules.

Key Procedures and Functions

Two procedures are documented for this package:

• DO_MASS_CHANGE — The primary driver procedure. It performs the actual application of a defined mass change against the qualifying asset population. This includes identifying the affected assets, validating that the requested change is permissible for each asset, writing the resulting transaction records, and updating the asset and book rows to reflect the new values.
• WRITE_MESSAGE — A message-handling routine used to report status and diagnostic information back to the caller. It supports the user-facing feedback that accompanies a mass change run, such as confirmation of the number of assets processed or notification of records that could not be updated.

The documented parameter lists are not exposed in the ETRM excerpt, so signatures should be confirmed against the live package specification before calling from custom code.

Tables Accessed

The package works across the core Oracle Assets tables via APPS synonyms:

• FA_MASS_CHANGES — Stores the definition of the mass change being executed, including the attributes to be modified. This is the controlling record for the operation.
• FA_ADDITIONS_B — The base asset table holding asset identification and descriptive information; read to identify the affected assets.
• FA_BOOKS — Holds the per-book asset cost and depreciation attributes that are updated by the mass change.
• FA_BOOK_CONTROLS — Provides book-level setup and control values, including the current depreciation period, needed to date the resulting transactions correctly.
• FA_METHODS — Supplies depreciation method definitions where the mass change alters method-related attributes.
• FA_TRANSACTION_HEADERS — Records the transaction headers generated by the change so that the activity is captured in the asset transaction history.
• PLITBLM — The standard Oracle Applications PL/SQL table type used for passing collections of identifiers or messages in memory.

Usage Notes

FA_MASSCHG_PKG is invoked from the Oracle Assets Mass Changes form, where the user defines the change and submits it for processing. In that flow the form calls the package to validate the change definition, execute DO_MASS_CHANGE, and return status messages via WRITE_MESSAGE. Because the package modifies FA_BOOKS and creates transaction header records, it should be treated as a transactional interface rather than a read-only utility.

Custom code should not call DO_MASS_CHANGE directly without understanding the locking, validation, and period-control implications handled by the standard form. Where integration is required, the preferred approach is to populate the mass change definition consistently with the form and invoke the package in a controlled environment, followed by verification of FA_BOOKS and FA_TRANSACTION_HEADERS. Testing should always be performed in a non-production instance first, since a misconfigured mass change can affect a large number of assets simultaneously.