Search Results fa_mass_rec_utils_pkg




Overview
Explore in AI Chat

Overview

APPS.FA_MASS_REC_UTILS_PKG is a utility package within the Oracle E-Business Suite Fixed Assets (FA) module. Its role is to support the Mass Reclassification feature, which allows organizations to change the asset category, and optionally the asset key and asset number, assigned to large groups of assets in a single operation rather than editing assets individually. The package provides the underlying PL/SQL infrastructure that prepares, validates, and loads asset reclassification data before the core mass reclassification process executes.

In EBS 12.1.1 and 12.2.2, the object is documented as VALID in the APPS schema and is classified as an "OTHER" API, meaning it is not a formally published public API. It is intended for internal use by the Fixed Assets application. It depends directly on APPS.FA_API_TYPES and the SYS.STANDARD package, and it is referenced by several other FA objects, notably the concurrent program packages FARX_RP and FARX_RR, the XML Publisher report packages FA_FASRCPVW_XMLP_PKG and FA_FASRCRVW_XMLP_PKG, and FA_MASS_RECLASS_PKG, which orchestrates the mass reclassification flow.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within this package:

  • GET_SELECTION_CRITERIA – Retrieves the selection criteria that define which assets are included in a mass reclassification run. This supports the user-defined range or grouping of assets to be processed.
  • COMPARE_CAT_MAJOR_SEGS – Compares the major segments of asset categories, supporting validation that a proposed reclassification is consistent with the category structure.
  • CONVERT_FORMATS – Converts data between formats as required when transferring or staging reclassification data for processing.
  • LOAD_CONVERSION_TABLE – Loads the conversion or staging table used to hold reclassification data prior to validation and posting.
  • INSERT_ITF – Inserts records into the interface table (FA_MASS_RECLASS_ITF), which is the standard Fixed Assets interface mechanism for loading data into the application.

No parameter lists are documented, and callers should treat these as internal routines whose signatures are subject to change between releases.

Tables Accessed

The package reads and writes several Fixed Assets and Oracle Application Object Library tables through APPS synonyms. FA_MASS_RECLASS and FA_MASS_RECLASS_ITF are central: the former holds mass reclassification definitions and the latter is the interface table populated by INSERT_ITF. FA_BOOK_CONTROLS and FA_SYSTEM_CONTROLS provide Fixed Assets setup and control information. FA_LOOKUPS supplies lookup values used during validation. FND_APPLICATION, FND_COLUMNS, FND_TABLES, FND_CURRENCIES, FND_ID_FLEX_STRUCTURES, and FND_ID_FLEX_SEGMENTS supply application registration, table/column metadata, currency, and key flexfield structure and segment information needed for category and segment validation (supporting COMPARE_CAT_MAJOR_SEGS). PLITBLM is a standard Oracle PL/SQL table used for in-memory list processing.

Usage Notes

FA_MASS_REC_UTILS_PKG is normally invoked indirectly. Users run the Mass Reclassification feature through the Fixed Assets forms or the associated concurrent programs (FARX_RP, FARX_RR) and XML Publisher reports, all of which reference this package. It is also called by FA_MASS_RECLASS_PKG, which drives the overall reclassification workflow. Because it is classified as OTHER and is not a published API, custom code should avoid calling these routines directly; any dependency on this package risks breakage during patching or upgrades. Developers who need mass reclassification functionality should use the documented concurrent programs and forms, or the formal Fixed Assets APIs, rather than this utility package.