Search Results fa_gainloss_und_pkg




Overview
Explore in AI Chat

Overview

FA_GAINLOSS_UND_PKG is an Oracle E-Business Suite Fixed Assets package owned by the APPS schema and stored in a VALID state in both 12.1.1 and 12.2.2. Its name reflects its purpose: the calculation and valuation of gain or loss amounts arising from asset retirements and revaluations, with the "_UND" suffix indicating a supporting or underlying layer that performs the core computational work. The package is a dependency-bearing component of the Fixed Assets tax and reporting machinery rather than a standalone API. It is referenced by FA_GAINLOSS_PRO_PKG, the sibling package that exposes the processing-level entry points, and it consumes the shared type definitions FA_API_TYPES, FA_RET_TYPES, and FA_STD_TYPES. Because FA_STD_TYPES appears in the dependency list, installations that search for "fa_std_types" and reach this object will find that FA_GAINLOSS_UND_PKG is one of the packages whose compiled signature is bound to that type specification. Any invalidation or change to FA_STD_TYPES can therefore invalidate FA_GAINLOSS_UND_PKG, which in turn affects FA_GAINLOSS_PRO_PKG. The ETRM classification for this object is OTHER, meaning it is an internal utility package and not part of the public Fixed Assets API surface.

Key Procedures and Functions

ETRM documents ten procedures or functions within this package:

  • FAGIAR — gain or loss computation associated with asset adjustments and revaluation.
  • FAGTAX — gain or loss determination for tax book processing.
  • FAGIAT — gain or loss handling for asset transfers between books or distributions.
  • FAGICT — gain or loss processing for categories, drawing on category book defaults.
  • FAGIAV — gain or loss calculation tied to asset valuation or revaluation events.
  • FARAJE — adjustment journal entry generation for retirement gain or loss.
  • FAGIDN — gain or loss determination for depreciation-related processing.
  • FAGIRV — gain or loss handling for revaluation transactions.
  • FAGRIN — retirement gain or loss income computation.
  • FAGIAVRR — gain or loss for asset revaluation and retirement reconciliation.

The procedures collectively derive gain, loss, and associated journal amounts from depreciation summaries, book controls, and adjustment history, exposing results to the calling processing package. Parameter lists are not published in the ETRM extract and are consequently not reproduced here.

Tables Accessed

The package reads and writes through APPS synonyms. Asset master and descriptive data come from FA_ADDITIONS_B. Book and category configuration are read from FA_BOOKS, FA_BOOK_CONTROLS, and FA_CATEGORY_BOOKS, while depreciation period control is read from FA_DEPRN_PERIODS and accumulated amounts from FA_DEPRN_SUMMARY. Transactional detail is drawn from FA_ADJUSTMENTS, FA_ASSET_HISTORY, FA_DISTRIBUTION_HISTORY, and FA_DISTRIBUTION_HISTORY_S. The multi-currency counterparts — FA_MC_ADJUSTMENTS, FA_MC_BOOKS, FA_MC_BOOK_CONTROLS, FA_MC_DEPRN_SUMMARY, and FA_MC_RETIREMENTS — are used when the asset book is a reporting or multi-currency book, allowing gain or loss to be computed consistently in the secondary currency.

Usage Notes

FA_GAINLOSS_UND_PKG is not invoked directly from the Fixed Assets forms or concurrent programs. It is called from FA_GAINLOSS_PRO_PKG, which is the only documented referencing package besides the package body itself. Typical execution paths are the Fixed Assets retirement and revaluation workflows and the associated gain/loss reporting and accounting processes, where FA_GAINLOSS_PRO_PKG passes control to the underlying procedures in this package. Custom code should target the public processing layer or the documented Fixed Assets APIs rather than calling FA_GAINLOSS_UND_PKG directly, since its signature is bound to internal type definitions such as FA_STD_TYPES and FA_RET_TYPES and is subject to change between releases. When troubleshooting invalid objects in a 12.1.1 or 12.2.2 environment, recompiling FA_STD_TYPES may be required to restore validity to both FA_GAINLOSS_UND_PKG and its caller.