Search Results do_retirement_adjustment




Overview
Explore in AI Chat

Overview

The APPS.FA_RETIREMENT_ADJUSTMENT_PVT package is a private (PVT) PL/SQL API belonging to the Oracle Assets (FA) module. It encapsulates the business logic required to compute and apply financial adjustments arising from the retirement or partial retirement of a fixed asset. When an asset is retired, the system must recognize the cost of removal, account for any proceeds received from disposal, and re-derive depreciation and financial balances for the affected asset. This package performs that recalculation and returns updated asset financial and depreciation records to its caller.

Because the package is classified as PVT, it is not intended as a public integration surface. It is a supporting implementation unit invoked internally by the Assets transaction APIs and processes rather than being called directly by external customizations.

Key Procedures and Functions

  • do_retirement_adjustment — The single documented function in the package. It accepts the current transaction context record (px_trans_rec), the asset header record (px_asset_hdr_rec), descriptive, type, and category records, together with the pre-retirement asset financial and depreciation records. It also receives the cost-of-removal and proceeds amounts, with optional distribution account identifiers (ccid) and a log-level record. It returns the recalculated post-retirement financial record (x_asset_fin_rec_new) and depreciation record (x_asset_deprn_rec_new), and signals success or failure via a BOOLEAN return value. The parameters are passed as a mixture of IN, OUT NOCOPY, and IN OUT NOCOPY arguments, reflecting the in-place mutation of the transaction and header records.

Tables Accessed

  • FA_BOOK_CONTROLS — Read to obtain the depreciation and accounting rules governing the asset's depreciation book, which determine how retirement adjustments are calculated and posted.
  • FA_CATEGORY_BOOKS — Read to retrieve category-level book defaults and prorate conventions that influence the depreciation recalculation performed during the retirement adjustment.

These tables are accessed through APPS synonyms. The financial and depreciation records themselves are passed by the caller in the parameter list rather than being persisted directly by this package.

Usage Notes

FA_RETIREMENT_ADJUSTMENT_PVT is referenced by one other package, indicating it operates as a subordinate utility within the Assets transaction API stack. It is typically invoked during asset retirement processing — for example, from the higher-level retirement or adjustment APIs — rather than from forms or concurrent programs directly. Because it is a private package, it should not be treated as a supported public API. Custom code requiring retirement adjustment behavior should call the documented public Assets APIs instead of this internal unit. Its behavior is consistent across Oracle EBS 12.1.1 and 12.2.2.