Search Results fa_cua_gain_loss_ext_pkg




Overview
Explore in AI Chat

Overview

APPS.FA_CUA_GAIN_LOSS_EXT_PKG is a PL/SQL package in the Oracle E-Business Suite Fixed Assets (FA) module. It belongs to the CUA (Common User Access / mass-update related) extension family of packages and has been classified under the API classification category of OTHER, indicating it is not a standard public business API but rather an extension or helper package supporting Fixed Assets processing logic. Its status is VALID in the APPS schema, and it is delivered as both a package specification and a package body.

The package name suggests its business purpose: it supports the computation and processing of gain or loss amounts associated with asset retirements, transfers, or mass updates. In Fixed Assets, gain/loss calculations are required whenever an asset is retired or otherwise disposed of, since the difference between net book value and proceeds (or between book values across books) determines the accounting gain or loss posted to the general ledger. This extension package provides reusable logic that the CUA mass-update framework or related CUA processing routines invoke to perform those gain/loss computations, particularly where a CUA (constant-usage assumption or user-defined extension) context requires customized calculation.

The package depends on APPS.FA_API_TYPES, the collection type package used throughout the Fixed Assets API layer, confirming that it operates on asset and book records structured using standard FA API datatypes.

Key Procedures and Functions

The documented package exposes a single program unit:

  • FACUAS1 — The sole documented procedure or function within the package. Based on naming convention and the package's stated purpose, FACUAS1 encapsulates the core gain/loss computation logic used by the CUA extension path. It is invoked by the package body to evaluate asset, book, and period data and determine the gain or loss amounts relevant to a given CUA scenario. Detailed parameter lists are not published in the ETRM metadata; callers should treat FACUAS1 as an internal helper rather than a formally supported public API.

No additional documented procedures or functions are present in the package.

Tables Accessed

The package references the following tables (through APPS synonyms) to obtain the data required for gain/loss processing:

  • FA_ASSET_HIERARCHY — Provides the asset hierarchical/parent-child relationship data used when gain/loss treatment must consider groupings or rollups.
  • FA_BOOKS — Supplies book-level definition data, including the depreciation book assigned to the asset, needed to determine which books participate in the gain/loss calculation.
  • FA_DEPRN_PERIODS — Provides depreciation period status and open/close information, ensuring gain/loss computations reference a valid accounting period.
  • FA_MASS_UPDATE_BATCH_DETAILS — Holds the individual asset records selected within a mass update batch, which the extension processes to compute expected gain/loss values.
  • FA_MASS_UPDATE_BATCH_HEADERS and FA_MASS_UPDATE_BATCH_HDRS_S — Provide the batch header (and its sequence-generated key) context that ties together the detail records being processed.
  • DUAL — Used for simple singleton queries and PL/SQL expression evaluation.

Usage Notes

This package is not a directly called public API. It is referenced only by itself (its package body), and no other packages in the APPS schema depend on it, which indicates it functions as a private extension invoked through the Fixed Assets CUA mass-update processing flow. Typical invocation occurs when a mass update batch involving retirements or value adjustments is processed and the associated gain/loss extension logic must be executed. In environments where the CUA gain/loss extension has been configured, the mass-update concurrent programs and supporting forms call into this package to derive the gain or loss figures before posting.

Because the package is a delivered, VALID object in the APPS schema, customizations should avoid modifying it in place; instead, standard Oracle practice is to preserve the delivered package and implement site-specific logic through supported extension hooks or by copying logic into a custom package. When troubleshooting gain/loss results from CUA mass updates in either EBS 12.1.1 or 12.2.2, this package is a key object to review, since its FACUAS1 routine drives the underlying computation. Its dependency on FA_MASS_UPDATE_BATCH_HEADERS and related tables also makes it relevant when diagnosing batch-level failures or when auditing how gain/loss values were populated on a mass-update batch.