Search Results fa_gainloss_upd_pkg




Overview
Explore in AI Chat

Overview

FA_GAINLOSS_UPD_PKG is an Oracle E-Business Suite Applications (APPS) schema PL/SQL package that belongs to the Oracle Assets (FA) module. Its name indicates its role in the gain and loss accounting process that arises when a fixed asset is retired, revalued, or otherwise disposed of at an amount that differs from its net book value. In Oracle Assets a gain or loss on retirement is computed as the difference between the retirement proceeds and the net book value of the retired units, and that amount must be recognised in the appropriate gain/loss accounts defined on the asset category and book. FA_GAINLOSS_UPD_PKG encapsulates the update logic that populates and maintains the gain/loss accounting records generated during retirement processing and the associated depreciation and book maintenance cycles.

The package is classified under ETRM as an OTHER API rather than as a published open interface, meaning it is an internal utility package used by Oracle Assets processing rather than a documented extension point for customer integrations. It carries a VALID status in the APPS schema, and the ETRM dependency listing confirms it depends on the shared Oracle Assets type definitions FA_API_TYPES, FA_RET_TYPES, and FA_STD_TYPES, which supply the record and table-type structures used to pass asset, book, and retirement data between the Assets PL/SQL layers.

Key Procedures and Functions

ETRM documents six procedures or functions within FA_GAINLOSS_UPD_PKG. The abbreviated names follow the Oracle Assets naming convention: FAGUST, FAGUCT, FAGURT, FARBOE, FAGPDP, and FAGPRV.

  • FAGUST — Standard processing routine within the gain/loss update package, associated with the FA_STD_TYPES type definitions used by standard asset transactions.
  • FAGUCT — Control or validation routine invoked in the gain/loss update flow to prepare and check the data required before accounting records are written.
  • FAGURT — Retirement handling routine, aligned with FA_RET_TYPES, used when gain/loss amounts are generated for retired asset units.
  • FARBOE — Book-of-entry related routine that ensures gain/loss figures are updated in the correct depreciation book and accounting context.
  • FAGPDP — Period depreciation processing routine that supports the interaction between gain/loss updates and depreciation period balances.
  • FAGPRV — Provisioning or proration routine that prepares gain/loss values prior to their final update.

Because the ETRM specification does not publish parameter signatures for these units, they should be treated as internal calls and not be invoked directly from custom code without Oracle guidance.

Tables Accessed

The documented table references show that the package operates across the core Oracle Assets accounting tables:

These references indicate the package both reads asset and depreciation data and writes the gain/loss adjustments needed to keep book balances consistent after retirement or revaluation events.

Usage Notes

FA_GAINLOSS_UPD_PKG is invoked indirectly. ETRM records show that FA_GAINLOSS_RET_PKG references FA_GAINLOSS_UPD_PKG and that it is referenced within its own package body, confirming that retirement processing in Oracle Assets calls this package internally. Typical call paths include the Asset Workbench and mass retirements functionality, the Retirements and Gain/Loss concurrent programs (such as the Calculate Gains and Losses and Periodic Asset Processing programs), and the depreciation and period-close runs that must reconcile disposal accounting. In Oracle EBS 12.1.1 and 12.2.2 the package resides in the APPS schema and is compiled against the Oracle Assets shared type packages; because it is undocumented as a public API, customisations should not call it directly. Report writers and auditors can, however, rely on the FA_ADJUSTMENTS, FA_ASSET_HISTORY, and FA_DEPRN_* tables it maintains to trace gain/loss postings.