Search Results validate_adjustment

Overview

APPS.FA_REC_PVT_PKG2 is a private Oracle E-Business Suite package body that supports the asset reclassification logic in Oracle Assets. Its specific role is to validate and prepare depreciation rule information when an asset is being redefaulted or adjusted due to a change in category, book, or related depreciation attributes. The package is part of the internal validation layer that the public Assets APIs invoke before committing a reclassification or adjustment. In that sense it is not intended to be called directly by end users or external integrations; it is a helper package whose functions evaluate whether existing depreciation rules stored on the asset differ from the rules that would apply after the change, and it derives the values required to drive subsequent processing. The header revision indicates maintenance through Release 12.1.1 and 12.2.2 (FAXVRC2B.pls, version 120.5).

Key Procedures and Functions

The documented package exposes two program units.

• VALIDATE_REDEFAULT — The function shown in the source excerpt. It accepts an asset identifier, a new category identifier, a book type code, an amortization flag, and an MR request identifier, and returns a Boolean result. It retrieves the current depreciation rules from the FA_BOOKS row for the asset and book, then calls FA_LOAD_TBL_PKG.Get_Deprn_Rules to determine the depreciation rules that would apply after redefault. It returns output values describing the old and new rules, whether rule changes exist, the rule usage indicator, the prorate date, and the rate source and depreciation basis rules. When no new rule set is found it raises an error through FA_SRVR_MSG.Add_Message.
• VALIDATE_ADJUSTMENT — This is the function relevant to the search term “validate_adjustment.” It performs the analogous validation path for adjustments rather than redefaults, confirming that the depreciation attributes associated with an adjustment are internally consistent with the asset, book, and book control data before the adjustment proceeds.

Tables Accessed

The package reads from and references several Assets tables through APPS synonyms.

• FA_ADDITIONS — The master asset definition table, used to confirm the asset exists and to supply asset-level attributes needed during validation.
• FA_BOOKS — The asset-to-book assignment table. The Validate_Redefault cursor queries it for the active row (date_ineffective IS NULL) to obtain the current depreciation rules: placed-in-service dates, prorate convention, method, life, rates, capacity, bonus rule, ceiling, depreciation flag, and salvage values.
• FA_BOOK_CONTROLS — The book setup table, supplying book-level defaults and control settings used to validate that proposed rules are permitted for the book.
• FA_DEPRN_SUMMARY — The depreciation summary table, referenced to assess existing depreciation accumulated against the asset when validating adjustments.

Usage Notes

FA_REC_PVT_PKG2 is invoked indirectly. Reclassification, category change, and adjustment flows in Oracle Assets — typically initiated from the Asset Workbench or the public Assets APIs — call into this package to validate rules before posting changes. It is also referenced by one other package in the ETRM catalog. Because it is classified as a private package, direct calls from custom code are discouraged; developers should use the supported public Assets APIs, which manage the sequencing of these validations and the associated FA_SRVR_MSG error handling. Any custom invocation must supply a valid log_level_rec and must not assume that VALIDATE_REDEFAULT or VALIDATE_ADJUSTMENT commits work; these functions are read-only validators that return status and populate out parameters for the caller to act upon.