Search Results validate_reclass_basic

Overview

FA_REC_PVT_PKG1 is a private PL/SQL package in the Oracle E-Business Suite Fixed Assets (FA) module, owned by the APPS schema. It encapsulates the internal validation logic that governs asset reclassification transactions. Reclassification in Oracle Assets refers to the process of changing an asset's category, and optionally its depreciation rules and account assignments, without retiring or re-adding the asset. Because such a change can materially affect depreciation calculations, account balances, and reporting, the system performs a battery of pre-transaction checks before permitting the reclass to proceed.

FA_REC_PVT_PKG1 is declared with AUTHID CURRENT_USER, meaning its runtime privileges are resolved against the invoking user's schema rather than the package owner. The package is classified as OTHER in the ETRM metadata and is referenced by one other package. Its role is strictly internal: it is not a public API but rather a supporting engine called by FA_REC_PUB_PKG, the published reclassification public API. The user search term "validate_reclass_basic" corresponds to the package's headline documented function, which orchestrates the validation sequence for a basic reclass — a category and account change with no depreciation rule redefaulting.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions within FA_REC_PVT_PKG1:

• VALIDATE_RECLASS_BASIC — The primary validation function. It checks whether a basic reclass transaction, limited to a change of category and associated account information with no depreciation rule redefaulting, can be performed. It accepts the asset identifier, the old and new category identifiers, a mass request identifier, and an output parameter for the current category type, returning a BOOLEAN result of TRUE for success or FALSE for failure. The source header explicitly notes that it is called from FA_REC_PUB_PKG.Reclass_Asset, the reclass public API. It delegates detailed checks to child modules within the package.
• CHECK_RETIREMENTS — A validation function that determines whether the asset has been fully retired in any book or has a pending retirement recorded against it. Such conditions block reclassification because an asset cannot be reclassified while its retirement status is unresolved. It returns a BOOLEAN and is called directly from VALIDATE_RECLASS_BASIC.
• VALIDATE_CATEGORY_CHANGE — A validation routine supporting the category-change portion of the reclass. It confirms that the transition from the existing category to the target category is permissible, drawing on category and category-book configuration data.
• CHECK_TRANS_DATE — A validation routine that verifies the transaction date for the reclass falls within an open depreciation period. Reclassification postings are period-sensitive, and an invalid or closed transaction date must be rejected before any data is modified.

Tables Accessed

The package accesses the following tables through APPS synonyms:

• FA_ADDITIONS — The master asset table, read to confirm the asset exists and to retrieve its current attributes.
• FA_CATEGORIES and FA_CATEGORY_BOOKS — Category definitions and their book-level defaults, consulted to validate the old-to-new category transition.
• FA_BOOKS and FA_BOOK_CONTROLS — Asset book balances and book control settings, used to determine the asset's book context and posting rules.
• FA_DEPRN_PERIODS — Depreciation calendar periods, used by CHECK_TRANS_DATE to confirm the transaction date sits in an open period.
• FA_RETIREMENTS — Retirement records, read by CHECK_RETIREMENTS to detect full or pending retirements.
• FA_ASSET_HISTORY and FA_DISTRIBUTION_HISTORY — Historical asset and distribution records, referenced during validation to preserve audit continuity.
• FA_TRANSACTION_HEADERS — Transaction header records, associated with mass reclass requests identified by the mass request identifier parameter.

Usage Notes

FA_REC_PVT_PKG1 is a private package and is not intended for direct invocation by custom code. Its entry point, VALIDATE_RECLASS_BASIC, is called by FA_REC_PUB_PKG.Reclass_Asset, the supported public API for asset reclassification. Consequently, the package is exercised whenever a reclass is submitted through the Oracle Assets forms, through the public API layer, or through mass reclassification concurrent processes that reference a mass request identifier. Developers integrating with Oracle Assets should call FA_REC_PUB_PKG rather than this package, since the private package's interface is subject to change between releases, including patch levels such as 120.4 noted in the source header. The AUTHID CURRENT_USER declaration also means any direct call must be made from a schema with the appropriate grants on the underlying FA tables.