Search Results fa_mc_upg2_pkg




Overview
Explore in AI Chat

Overview

FA_MC_UPG2_PKG is a multi-currency upgrade utility package in the Oracle E-Business Suite Fixed Assets (FA) module. Its primary business function is to convert and migrate Fixed Assets data from a single-currency (or primary set of books) environment into a multi-currency reporting environment, populating the MRC (Multiple Reporting Currencies) tables such as FA_MC_BOOKS, FA_MC_ADJUSTMENTS, and FA_MC_ASSET_INVOICES. The package operates under AUTHID CURRENT_USER, meaning all unqualified object references resolve through the caller's schema and the APPS synonyms.

The "UPG2" suffix indicates this is a second-generation upgrade routine, executed during the multi-currency migration or upgrade path for a reporting set of books (RSOB). It performs rate-based conversion of monetary amounts using a numerator/denominator rate pair, an MAU (Multi-Asset Unit or minimum accountable unit) indicator, and a precision value, and then rounds converted balances and retirements to satisfy FA's stored-amount constraints.

Key Procedures and Functions

The package exposes ten documented procedures. Each monetary conversion routine consistently accepts a reporting set of books id (p_rsob_id), a book type code (p_book_type_code), a numerator and denominator rate (p_numerator_rate, p_denominator_rate), an MAU indicator (p_mau), and a precision argument (p_precision) — the exact parameter the user searched for.

  • CONVERT_BOOKS — Converts the primary FA_BOOKS balances into the equivalent multi-currency book records for the reporting set of books, applying the supplied rates and precision.
  • CONVERT_INVOICES — Converts asset invoice amounts recorded in FA_ASSET_INVOICES into the multi-currency invoice table.
  • INSERT_BKS_RATES — Inserts the conversion rates associated with a book into the rate repository used by the multi-currency books.
  • CONVERT_ADJUSTMENTS — Converts adjustment transactions, scoped by a start and end period (p_start_pc, p_end_pc), into the multi-currency adjustment table.
  • ROUND_RETIREMENTS — Post-conversion rounding cleanup for retirement amounts, driven by book type and reporting set of books.
  • CONVERT_RETIREMENTS — Converts retirement transactions over a period range using the supplied rates and precision.
  • CONVERT_DEPRN_SUMMARY — Converts depreciation summary balances, additionally accepting a p_convert_order argument to control processing sequence.
  • CONVERT_DEPRN_DETAIL — Converts depreciation detail (transaction-level) rows for the reporting set of books.
  • CONVERT_DEPRN_PERIODS — Converts depreciation period definitions and status over the specified period range.
  • CONVERT_DEFERRED_DEPRN — Converts deferred depreciation amounts, applying the numerator rate during the period range.

Tables Accessed

The package reads and writes through APPS synonyms. Source/primary-side 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, and FA_DISTRIBUTION_HISTORY. Target multi-currency tables written by the conversion routines are FA_MC_ADJUSTMENTS, FA_MC_ASSET_INVOICES, FA_MC_BOOKS, and FA_MC_BOOKS_RATES. FA_BOOK_CONTROLS governs period status logic, while the FA_DEPRN_* and FA_ASSET_HISTORY tables carry the balances being translated.

Usage Notes

FA_MC_UPG2_PKG is an upgrade/migration utility rather than a runtime API, and is not intended for routine business transactions. It is typically invoked by the multi-currency upgrade driver and related concurrent program logic when a reporting set of books is being populated from an existing primary book. Because it is referenced by one other package (per ETRM metadata), that caller is the standard entry point; direct invocation by custom code should be limited to controlled migration scenarios. The p_precision parameter controls decimal rounding during conversion, and the p_numerator_rate/p_denominator_rate pair supplies the effective conversion rate; p_mau determines how amounts are rounded to the minimum accountable unit. No documented functions exist in this package — only procedures.