Search Results get_adj_balances

Overview

APPS.FA_MC_UPG3_PKG is a PL/SQL package in Oracle E-Business Suite that supports the multi-currency (MC) upgrade and conversion processing for Oracle Assets (Fixed Assets). Its header comment and declared AUTHID CURRENT_USER directive, together with the FA_MC_* tables it references, identify it as an internal upgrade utility responsible for populating and validating multi-currency reporting book balances during the transition of a primary (corporate) book into a reporting book structure. The "UPG3" naming convention places it in the family of upgrade-phase packages executed by the Assets multi-currency conversion process, sitting alongside companion packages that prepare book controls, conversion rates, and conversion history rows.

The package is classified as OTHER in the ETRM 12.2.2 API registry, meaning it is not a published public API but an internal, versioned component (header identifier faxmcu3s.pls 120.3). It is invoked by the Assets concurrent conversion and upgrade programs rather than by end users directly, and it is referenced by one other package within the same upgrade code set.

Key Procedures and Functions

The package exposes fifteen documented procedures, none of which are functions. They fall into four functional groups:

• Validation routines: CHECK_CONVERSION_STATUS verifies that multi-currency conversion has reached a valid state for a reporting set of books, while CHECK_PERIOD_POSTED confirms that the relevant depreciation periods within a book have been posted before balance processing continues.
• Balance calculation: CALCULATE_BALANCES drives the population of reporting-book balances from source-book data for a given reporting book and book type.
• Balance retrieval routines: GET_ADJ_BALANCES, GET_DEPRN_RESERVE_BALANCES, GET_DEPRN_EXP_BALANCES, GET_REVAL_RSV_BALANCES, GET_REVAL_AMORT_BALANCES, GET_DEF_RSV_BALANCES, and GET_DEF_EXP_BALANCES each extract a specific balance component — adjustments, depreciation reserve, depreciation expense, revaluation reserve, revaluation amortization, deferred reserve, and deferred expense — for processing into the reporting book.
• Chart of accounts and insertion routines: FIND_CCID locates a code combination identifier for a given adjustment type, returning a found flag and index; GET_COA_INFO retrieves chart of accounts information for a book; INSERT_RET_EARNINGS writes retained earnings rows; INSERT_BALANCES inserts calculated balance records; and INSERT_REC inserts an individual balance record using entered and accounted debit/credit amounts together with a CCID.

Tables Accessed

Table access is through APPS synonyms and spans both the primary Assets tables and their multi-currency counterparts. Source data is read from FA_BOOK_CONTROLS, FA_CATEGORY_BOOKS, FA_DEPRN_PERIODS, FA_DEPRN_DETAIL, FA_ADJUSTMENTS, FA_DEFERRED_DEPRN, FA_ASSET_HISTORY, and FA_DISTRIBUTION_HISTORY. Multi-currency targets and drivers include FA_MC_BOOK_CONTROLS, FA_MC_DEPRN_DETAIL, FA_MC_ADJUSTMENTS, FA_MC_DEFERRED_DEPRN, FA_MC_CONVERSION_RATES, and FA_MC_CONVERSION_HISTORY. Account generation relies on FND_ID_FLEX_SEGMENTS to resolve key flexfield segment definitions when deriving CCIDs for balance insertion.

Usage Notes

FA_MC_UPG3_PKG is an upgrade-time utility, not a runtime transaction API. It is normally invoked by the Assets multi-currency upgrade or conversion concurrent programs during the release upgrade or when establishing a reporting book against an existing primary book. Because the package is AUTHID CURRENT_USER and classified as OTHER, it must be treated as internal: direct calls from custom code are unsupported, and any dependency carries upgrade risk, as the $Header version stamp indicates the source has been revised across releases. When diagnosing conversion issues, DBAs and functional consultants typically review the validation procedures first to confirm conversion status and posted periods before balance extraction and insertion routines are allowed to execute.