Search Results fa_reclass_pub




Overview
Explore in AI Chat

Overview

FA_RECLASS_PUB is a public PL/SQL package in the APPS schema that exposes Oracle E-Business Suite functionality for reclassifying fixed assets. Reclassification in Oracle Assets allows an organization to change the assignment of an asset — most commonly moving it to a different asset category, but also adjusting distribution lines, locations, or other descriptive classifications — without disposing of the asset or altering its cost and depreciation history in unintended ways. The package serves as the programmatic interface behind the Asset Reclassification window in the Oracle Assets forms and behind concurrent programs that perform mass reclassification.

As a public (PUB) API in the ETRM 12.2.2 taxonomy, FA_RECLASS_PUB is intended to be called by other Oracle applications and by customer extensions. It encapsulates the business rules, validation logic, and table maintenance required to keep the asset records, book balances, and depreciation calendars consistent after a reclassification. The package status is VALID and it is owned by APPS, which is the standard schema for Oracle EBS public APIs.

Key Procedures and Functions

The documented interface exposes a single program unit:

  • DO_RECLASS — The reclassification routine. It applies the requested classification change to the specified asset, performing the validations and updates needed to keep the asset record and its associated book and period data synchronized. Detailed parameter lists are not published in the metadata; callers should obtain the exact signature from the package specification in the EBS database before coding against it.

Because PUB APIs are written to be forward compatible, the signature and behavior of DO_RECLASS should be treated as the supported entry point, and internal procedures in the package body should not be invoked directly.

Tables Accessed

FA_RECLASS_PUB reads and writes the core Oracle Assets tables, referenced through APPS synonyms:

  • FA_ADDITIONS — The master asset table holding asset identifying information, including the asset category and descriptive attributes that reclassification modifies.
  • FA_ASSET_HIERARCHY — Stores parent/child relationships between assets, which may need to be preserved or adjusted when an asset is reclassified.
  • FA_BOOKS — Holds the per-book asset balances, including cost, salvage, and depreciation attributes that are affected when the asset category changes.
  • FA_BOOK_CONTROLS — Defines the books and their accounting rules; used to validate that the reclassification is permitted in each book.
  • FA_DEPRN_PERIODS — The depreciation calendar per book; used to determine the open period in which the reclassification takes effect and to ensure the transaction is recorded in a valid period.

The package also depends on FA_API_TYPES, FND_API, FND_GLOBAL, and the SYS STANDARD package, which provide the standard EBS API error-handling, message, and environment conventions.

Usage Notes

FA_RECLASS_PUB is invoked from several Oracle Assets components rather than being called directly by end users. Within Oracle EBS it is referenced by FA_CUA_MASS_UPDATE1_PKG, FA_MASSADD_PKG, FA_MASS_RECLASS_PKG, FA_TRANS_API_PUB, and CSE_ASSET_MOVE_PKG, confirming that the Asset Reclassification form and the mass reclassification and mass addition concurrent programs all route through this package. Custom code should call DO_RECLASS only after initializing the FND_GLOBAL application context and handling FND_API error and message stacks. Reclassification should be performed in an open depreciation period, and callers must respect the book controls configured for the asset's books.