Search Results check_criteria

Overview

APPS.FA_MASS_RECLASS_PKG is a PL/SQL package in the Oracle E-Business Suite Fixed Assets module (FA) that supports the Mass Reclassification business process. Mass reclassification allows an organization to change asset categorization attributes — such as asset category, asset key, and related descriptive or accounting flexfield segments — for many assets simultaneously, rather than editing each asset individually through the Assets form. This is a common requirement when a company reorganizes its chart of accounts, restructures asset categories, or corrects categorization errors that affect large populations of assets.

The package encapsulates the validation, date checking, message handling, and processing logic required to submit and execute a mass reclassification run. It is registered in the APPS schema and holds a VALID status in the ETRM repository, confirming it is an active, compiled database object in both Oracle EBS 12.1.1 and 12.2.2 environments. Its API classification in the repository is OTHER, meaning it is a backend processing package rather than a public, documented open interface API.

Key Procedures and Functions

The ETRM metadata documents four procedures within the package:

• DO_MASS_RECLASS — The primary driver procedure that performs the mass reclassification processing. It applies the defined reclassification criteria to the eligible asset population and updates the affected asset records.
• CHECK_TRANS_DATE — Validates the transaction date supplied for the reclassification, ensuring the date falls within an open depreciation period and satisfies Fixed Assets date-control rules before processing proceeds.
• CHECK_CRITERIA — Validates the selection criteria entered by the user, confirming that the specified category, key, or segment combinations are structurally valid and permissible for reclassification.
• WRITE_MESSAGE — Handles message output, recording informational, warning, or error messages generated during validation and processing so they can be surfaced to the user or written to the request log.

Tables Accessed

The package reads and writes a defined set of Fixed Assets and general ledger tables through APPS synonyms:

• FA_ADDITIONS_B — The base asset definition table storing asset number, description, and asset key.
• FA_BOOKS — Stores per-book asset cost, category, and depreciation attributes; the principal target of category and asset key changes.
• FA_BOOK_CONTROLS — Book-level control information used to validate processing context.
• FA_DEPRN_PERIODS — Depreciation period calendar used by CHECK_TRANS_DATE to validate open periods.
• FA_DISTRIBUTION_HISTORY — Tracks assignment and distribution changes, supporting historical audit of reclassifications.
• FA_MASS_RECLASS — The interface/staging table holding the mass reclassification criteria and asset selections submitted for processing.
• FA_SYSTEM_CONTROLS — System-level FA setup options governing allowable processing behaviour.
• GL_CODE_COMBINATIONS — Account flexfield combinations validated when accounting segments are part of the reclassification.
• PLITBLM — A standard Oracle Applications message/log table used by WRITE_MESSAGE.

Usage Notes

FA_MASS_RECLASS_PKG is normally invoked indirectly rather than called from custom code. The ETRM dependency record shows it is referenced by the FARX_RP program unit, which corresponds to the Fixed Assets Mass Reclassifications concurrent program and its supporting report/processing logic. Users define reclassification criteria in the Mass Reclassifications window, which populates FA_MASS_RECLASS; the concurrent request then drives DO_MASS_RECLASS to validate the date and criteria and apply the updates.

Because the package is classified as OTHER rather than a supported open API, direct calls from custom PL/SQL are not recommended. Customers requiring automated or bulk reclassification should submit the standard concurrent program or build against documented open interfaces instead, so that period validation, distribution history, and message logging remain intact.