Search Results calculate_balances

Overview

APPS.FA_MC_UPG3_PKG is a multi-currency (MC) upgrade package in the Oracle E-Business Suite Fixed Assets module. Its role is to migrate and rebuild Multi-Currency accounting balances for asset books as part of the multi-currency upgrade path. The package consolidates cost, depreciation, revaluation, and adjustment data from both the primary (functional) books and the reporting (multi-currency) books, converts functional amounts into reporting currency amounts, and inserts the resulting balance records into the appropriate multi-currency tables.

Internally the package defines several PL/SQL collection types to manage the process. A ccid_table_rec record holds the entered (functional) and accounted (reporting) debit and credit amounts for a single accounting flexfield combination, while a ccid_table collection stores these records indexed by binary integer. Separate collections are maintained for depreciation reserve, depreciation expense, revaluation reserve, revaluation amortization, adjustments, deferred depreciation reserve, and deferred depreciation expense combinations. Global counters track the number of populated entries in each collection, and a flex_table collection stores the chart of accounts segment structure. Global variables such as G_book_class, G_coa_id, G_re_ccid, and G_insert_buf support book classification, account identification, and dynamic SQL generation.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions:

• CHECK_CONVERSION_STATUS — evaluates whether conversion has already been performed for a given reporting set of books and book type, preventing duplicate processing.
• CHECK_PERIOD_POSTED — determines whether a depreciation period has been posted and is therefore eligible for balance calculation.
• CALCULATE_BALANCES — the central routine that drives balance computation, aggregating functional amounts and deriving the corresponding reporting currency amounts.
• GET_ADJ_BALANCES — retrieves adjustment transaction balances for processing.
• GET_DEPRN_RESERVE_BALANCES — collects accumulated depreciation reserve amounts.
• GET_DEPRN_EXP_BALANCES — collects depreciation expense amounts for the period.
• GET_REVAL_RSV_BALANCES — collects revaluation reserve balances.
• GET_REVAL_AMORT_BALANCES — collects revaluation amortization balances.
• GET_DEF_RSV_BALANCES — collects deferred depreciation reserve balances.
• GET_DEF_EXP_BALANCES — collects deferred depreciation expense balances.
• FIND_CCID — resolves an accounting flexfield combination identifier for a given account structure.
• GET_COA_INFO — reads the chart of accounts structure, populating the flex segment collection.
• INSERT_RET_EARNINGS — inserts the retained earnings balance record produced by revaluation processing.
• INSERT_BALANCES — writes computed balance rows into the multi-currency balance tables.
• INSERT_REC — performs the low-level insertion of an individual balance record, typically using the dynamically generated insert buffer.

Tables Accessed

The package reads and writes a defined set of Fixed Assets tables through APPS synonyms. Primary book and asset data is drawn from FA_BOOK_CONTROLS, FA_CATEGORY_BOOKS, FA_ASSET_HISTORY, FA_DISTRIBUTION_HISTORY, FA_ADJUSTMENTS, FA_DEPRN_DETAIL, FA_DEPRN_PERIODS, and FA_DEFERRED_DEPRN. Multi-currency specific data is read from FA_MC_BOOK_CONTROLS, FA_MC_CONVERSION_HISTORY, FA_MC_CONVERSION_RATES, FA_MC_ADJUSTMENTS, FA_MC_DEPRN_DETAIL, and FA_MC_DEFERRED_DEPRN. Chart of accounts segment information is obtained from FND_ID_FLEX_SEGMENTS. The conversion rate and history tables supply the exchange rates used to translate functional amounts into reporting currency amounts, while the multi-currency detail tables receive the rebuilt balances.

Usage Notes

FA_MC_UPG3_PKG is an internal upgrade utility rather than a public API. It is typically invoked from the multi-currency upgrade concurrent program (or a parent upgrade driver) during the transition to multi-currency reporting, and it is referenced by one other package within the same upgrade family. Because it performs bulk inserts into FA_MC_* tables it should be executed only within the controlled upgrade window, with the reporting set of books and book type properly initialized. The CHECK_CONVERSION_STATUS routine guards against redundant execution. Debug output is controlled through fa_cache_pkg.fa_print_debug, allowing diagnostic tracing of the balance calculation and insertion steps.