Search Results fa_adjustments_s

Overview

FA_MC_UPG2_PKG is an Oracle E-Business Suite upgrade package in the APPS schema that supports the conversion and migration of Oracle Assets data for reporting books that operate in a secondary (reporting) currency. In Oracle Assets, the primary book records transactions in the functional currency, while a reporting book references the primary book and re-expresses transaction, cost, and depreciation amounts in a second currency. During the upgrade to EBS 12.1.1 or 12.2.2, especially with the Multiple Reporting Currencies (MRC) architecture, historical balances from the primary book must be converted and loaded into the associated reporting currency structures. FA_MC_UPG2_PKG performs that task by populating and reconciling the table pairs: primary tables such as FA_ADJUSTMENTS, FA_ASSET_INVOICES, FA_DEPRN_SUMMARY, FA_DEPRN_DETAIL, FA_DEPRN_PERIODS, FA_DEFERRED_DEPRN, and FA_RETIREMENTS against their reporting currency counterparts FA_MC_ADJUSTMENTS, FA_MC_ASSET_INVOICES, FA_MC_DEPRN_SUMMARY, FA_MC_DEPRN_DETAIL, FA_MC_DEPRN_PERIODS, FA_MC_DEFERRED_DEPRN, and FA_MC_RETIREMENTS. The package is classified as OTHER rather than a public API.

Key Procedures and Functions

The documented package exposes ten conversion procedures, each targeting a specific data area:

• CONVERT_BOOKS — establishes or validates the reporting-book context by converting book-related information into the reporting currency book tables.
• CONVERT_INVOICES — converts asset invoice (cost source) data from FA_ASSET_INVOICES to the reporting currency counterpart FA_MC_ASSET_INVOICES.
• INSERT_BKS_RATES — inserts book and currency rate rows used by the reporting currency conversion, populating rate reference structures such as FA_MC_BOOKS_RATES.
• CONVERT_ADJUSTMENTS — converts adjustment transactions from FA_ADJUSTMENTS into FA_MC_ADJUSTMENTS.
• ROUND_RETIREMENTS — applies rounding corrections to converted retirement amounts so currency conversion differences remain consistent.
• CONVERT_RETIREMENTS — converts retirement data into FA_MC_RETIREMENTS.
• CONVERT_DEPRN_SUMMARY — converts summarized depreciation balances into FA_MC_DEPRN_SUMMARY.
• CONVERT_DEPRN_DETAIL — converts detailed depreciation lines into FA_MC_DEPRN_DETAIL.
• CONVERT_DEPRN_PERIODS — converts depreciation period definitions into FA_MC_DEPRN_PERIODS.
• CONVERT_DEFERRED_DEPRN — converts deferred depreciation balances into FA_MC_DEFERRED_DEPRN.

Tables Accessed

The package reads from the source (primary book) tables and writes to their reporting currency counterparts. Source tables include FA_ADJUSTMENTS, FA_ADJUSTMENTS_S, FA_ASSET_HISTORY, FA_ASSET_INVOICES, FA_BOOKS, FA_BOOK_CONTROLS, FA_DEFERRED_DEPRN, FA_DEPRN_DETAIL, FA_DEPRN_PERIODS, FA_DEPRN_SUMMARY, FA_DISTRIBUTION_HISTORY, and FA_RETIREMENTS. Destination tables include FA_MC_ADJUSTMENTS, FA_MC_ASSET_INVOICES, FA_MC_BOOKS, FA_MC_BOOKS_RATES, FA_MC_CONVERSION_RATES, FA_MC_DEFERRED_DEPRN, FA_MC_DEPRN_DETAIL, FA_MC_DEPRN_PERIODS, FA_MC_DEPRN_SUMMARY, and FA_MC_RETIREMENTS. FA_ADJUSTMENTS_S is the primary key sequence source used when inserting converted adjustment rows, ensuring unique identifiers in FA_MC_ADJUSTMENTS. Supporting packages FA_CACHE_PKG, FA_DEBUG_PKG, and FA_SRVR_MSG provide caching, debugging, and server messaging support, while APP_EXCEPTION and STANDARD supply error handling.

Usage Notes

FA_MC_UPG2_PKG is an internal upgrade utility rather than a callable business API. It is typically invoked by Oracle Assets upgrade driver routines, concurrent upgrade programs, or one-off conversion scripts executed during the upgrade or patching process that migrates MRC reporting book data. The package is not referenced by any database object, indicating it is called dynamically or directly by upgrade logic. Because it performs bulk inserts and updates across many FA and FA_MC tables, it should be run only within the controlled upgrade window, with a validated backup and after FA_BOOK_CONTROLS status is confirmed. Custom code should not invoke these routines outside of upgrade scenarios.