Search Results calc_catchup

Overview

FA_GAINLOSS_DPR_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the calculation of gains and losses arising from asset retirements, including the treatment of depreciation reserve (DPR) balances. In Oracle Assets (FA), when a retired asset is disposed of, the system must determine the difference between the net book value and the proceeds of sale, and must reverse or reclassify the accumulated depreciation reserve associated with the asset. This package encapsulates a portion of that gain/loss logic, specifically the computation of catch-up amounts relating to depreciation reserve movements. It is a supporting utility within the broader family of FA_GAINLOSS packages — FA_GAINLOSS_RET_PKG, FA_GAINLOSS_UND_PKG, and FA_GAINLOSS_UPD_PKG — which together handle gain/loss processing for retirements, undo operations, and updates. FA_GAINLOSS_DPR_PKG is marked with an API classification of OTHER, meaning it is an internal Oracle component rather than a formally published public API.

Key Procedures and Functions

The ETRM documentation records two procedures/functions within this package:

• FAGCDP — The name follows Oracle Assets naming conventions (FA + Gain/Loss/Depreciation Reserve context). It serves as an entry point for the depreciation-reserve-related gain/loss computation, orchestrating the retrieval of book, method, and retirement data required to derive the reserve component of a retirement gain or loss.
• CALC_CATCHUP — This routine calculates catch-up adjustment amounts. In the assets depreciation model, catch-up amounts reconcile the difference between what depreciation was taken and what should have been taken following a change in method, life, or reserve arrangement. Within this package the catch-up logic is applied to the gain/loss and reserve treatment surrounding retired or adjusted assets.

No parameter lists are exposed in the documented metadata; consumers should reference the package header for exact signatures.

Tables Accessed

The package operates against the core Oracle Assets transactional and setup tables via APPS synonyms:

• Retirement data — FA_RETIREMENTS and FA_MC_RETIREMENTS store retirement transactions in the primary and multiple-reporting-currency books respectively.
• Adjustment and transaction data — FA_ADJUSTMENTS and FA_MC_ADJUSTMENTS hold cost and reserve adjustments, while FA_TRANSACTION_HEADERS groups transaction activity.
• Book and period data — FA_BOOKS, FA_MC_BOOKS, and FA_BOOK_CONTROLS supply book configuration and control information, while FA_DEPRN_PERIODS, FA_CALENDAR_PERIODS, and FA_CALENDAR_TYPES provide the depreciation and calendar periods that bound the catch-up calculation.
• Method and convention setup — FA_METHODS and FA_CONVENTIONS provide the depreciation method and prorate convention definitions used in deriving reserve amounts.

Dependencies and Usage Notes

FA_GAINLOSS_DPR_PKG depends on three APPS type packages — FA_API_TYPES, FA_RET_TYPES, and FA_STD_TYPES — confirming that it participates in the standard Oracle Assets API data structures, including the FA_RET_TYPES record types used for retirement processing. The object is referenced by three sibling packages: FA_GAINLOSS_RET_PKG, FA_GAINLOSS_UND_PKG, and FA_GAINLOSS_UPD_PKG, indicating it is invoked as a subordinate routine during retirement gain/loss, undo, and update workflows rather than called directly by forms or concurrent programs. In practice, gain/loss processing is triggered through the Retirements window in the Assets form or through mass retirement interfaces; the calling gains/losses packages in turn call this package to resolve the depreciation-reserve and catch-up component. Custom code should not invoke FA_GAINLOSS_DPR_PKG directly, as it is an internal implementation package subject to change; integrators requiring gain/loss functionality should use the documented public APIs.