Search Results fa_gainloss_pro_pkg




Overview
Explore in AI Chat

Overview

FA_GAINLOSS_PRO_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the gain and loss processing logic within the Oracle Assets (FA) module. Its role is closely tied to the calculation and accounting treatment of gains and losses that arise when assets are retired, revalued, or otherwise disposed of. The package forms part of the internal call stack used by Oracle Assets to derive, adjust, and post gain/loss amounts during retirement and revaluation workflows.

In the EBS 12.1.1 and 12.2.2 releases, the package carries a status of VALID in the ETRM dictionary and is classified as an OTHER API rather than a public, supported interface. It is not intended for direct external invocation; instead it participates as an internal helper invoked by higher-level gain/loss processing packages. This design reflects Oracle's layered approach in which the gain/loss domain is decomposed into a controlling package plus supporting routines for specialized calculations.

Key Procedures and Functions

The ETRM metadata documents a single named program unit within this package:

  • FAGPSA — the only documented procedure or function exposed by the package. Based on the package's naming and its position in the gain/loss call chain, FAGPSA implements a specific calculation or adjustment step for gain/loss processing. Detailed parameter lists are not published in the ETRM record, so direct calls should not be constructed from documentation alone.

Because only one routine is listed while the package body may contain additional private helpers, the documented surface reflects the externally visible entry point. Custom code should avoid relying on undocumented members of the package body, as Oracle reserves the right to modify these in patching.

Tables Accessed

The ETRM entry for FA_GAINLOSS_PRO_PKG does not enumerate base tables accessed through APPS synonyms. The package is shown to depend on the following declared types:

  • FA_API_TYPES — the shared record and table type definitions used across the Oracle Assets public APIs, providing the structured payloads passed into and out of gain/loss processing routines.
  • FA_RET_TYPES — the retirement-specific type definitions that carry asset retirement gain/loss attributes and result sets.
  • SYS.STANDARD — the Oracle-supplied STANDARD package, providing built-in PL/SQL functions such as TO_CHAR and TO_DATE used internally.

No APPS-synonymed base tables are listed in the excerpt, meaning table access is either performed indirectly through other packages in the chain or is not surfaced in the documented metadata.

Usage Notes

FA_GAINLOSS_PRO_PKG is referenced by APPS.FA_GAINLOSS_PKG, confirming that the primary consumer is the Oracle Assets gain/loss controller package rather than user-facing forms or concurrent programs. FA_GAINLOSS_PKG in turn is invoked during asset retirement, revaluation, and mass transaction processing to compute and persist gain/loss amounts.

Typical invocation paths include:

  • Oracle Assets forms — the Asset Workbench and retirement forms trigger the gain/loss chain when a retirement or revaluation is saved, indirectly invoking this package through FA_GAINLOSS_PKG.
  • Concurrent programs — processes such as mass retirements, revaluation, and depreciation posting route gain/loss calculations through the same controller.
  • Custom code — because the package is classified OTHER and not documented as a public API, direct calls from customizations are discouraged; integrators should call supported Oracle Assets APIs such as FA_RETIREMENT_API or FA_ADJUSTMENT_API, which internally reach the gain/loss packages.

Upgrades between 12.1.1 and 12.2.2 do not alter the package's APPS ownership or its dependency on FA_API_TYPES and FA_RET_TYPES, but any custom references should be revalidated after patching because the package body is subject to change.