Search Results fa_query_balances_pkg




Overview
Explore in AI Chat

Overview

FA_QUERY_BALANCES_PKG is a server-side PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Assets (FA) module and serves as an internal query and validation engine that returns asset balance information to callers such as the Oracle Assets forms, related Asset APIs, and dependent packages. The package does not post accounting entries or modify asset financial data; instead, it resolves period context, assembles depreciation and adjustment figures, and returns those results to the requesting program unit. Its classification within the ETRM repository is OTHER, meaning it is an internal, non-public API rather than a formally published extension interface.

The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. It is referenced by nineteen other database objects, confirming its role as a widely reused internal dependency, while it is not itself referenced outside the APPS schema by any external object.

Key Procedures and Functions

Seven documented program units make up the package interface:

  • QUERY_BALANCES — The primary entry point. It assembles asset balance information for a given asset and book, returning cost, depreciation, and adjustment values to the caller.
  • QUERY_BALANCES_INT — An internal variant of the main query routine, used to consolidate shared logic and to support internal recursion or multi-book processing without re-entering the public wrapper.
  • ADD_ADJ_TO_DEPRN — Combines adjustment amounts with depreciation balances so that a caller receives a net, adjustment-inclusive depreciation figure.
  • GET_PERIOD_INFO — Resolves depreciation calendar and period context, identifying the current open period and its associated book controls.
  • QUERY_DEPRN_SUMMARY — Retrieves summarized depreciation balances at the asset and book level from the depreciation summary tables.
  • QUERY_DEPRN_DETAIL — Retrieves period-by-period depreciation detail, used when a caller requires transactional granularity rather than summary totals.
  • GET_ADJUSTMENTS_INFO — Returns adjustment transactions applicable to the asset, book, and period under evaluation.

Together these units follow a layered pattern: establish period context, gather summary and detail depreciation, gather adjustments, and merge the results.

Tables Accessed

The package reads and, in limited internal processing, works with the core Oracle Assets transactional and balance tables through APPS synonyms. FA_BOOKS and FA_BOOK_CONTROLS supply book definition and period-control status. FA_DEPRN_PERIODS and FA_CALENDAR_TYPES establish the depreciation calendar and open-period boundaries used by GET_PERIOD_INFO. FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL provide the summarized and detailed depreciation balances. FA_ADJUSTMENTS and FA_TRANSACTION_HEADERS supply adjustment and transaction context. FA_MC_BOOKS, FA_MC_ADJUSTMENTS, FA_MC_DEPRN_SUMMARY, and FA_MC_DEPRN_DETAIL provide the corresponding multiple-reporting-currency (MC) equivalents, enabling the same queries to be executed for a reporting set of books. Supporting packages FA_CACHE_PKG, FA_DEBUG_PKG, FA_SRVR_MSG, FA_STANDARD_PKG, FA_STD_TYPES, and FA_API_TYPES are used for caching, diagnostics, message handling, and shared type and constant definitions.

Usage Notes

FA_QUERY_BALANCES_PKG is an internal package and is not intended as a supported customer extension point. It is typically invoked indirectly: Oracle Assets form logic, concurrent programs, and other Oracle-owned packages call it to display balances or to validate figures before a transaction is processed. Because the package is referenced by nineteen objects and depends on the FA_CACHE_PKG and FA_DEBUG_PKG utilities, customizations should not call it directly unless the calling code also initializes the same caching and debug context used by Oracle's own invocations. The presence of both primary and multiple-currency table references means callers must pass the appropriate book or reporting context so that the correct currency view is returned. Any modification to the package body risks invalidating dependent objects and is unsupported.