Search Results fa_mc_conversion_history




Overview
Explore in AI Chat

Overview

FA_MC_CONVERSION_HISTORY is a table owned by the FA schema in Oracle E-Business Suite, belonging to the OFA - Assets product family. As its description states, it stores the conversion history of primary to reporting books, providing an audit trail of the multi-currency (MC) conversion process used in Oracle Assets. When a reporting book is populated from a primary book, this table records the periods involved, the conversion status, the rate basis applied, and the resulting asset totals for each conversion cycle.

Under the heuristic Data Vault classification mined from its foreign key structure, this table is modeled as a link. That classification is a modeling suggestion rather than an enforced property: the table's role is to associate a set of books with a book type code and the depreciation periods governing a conversion event, placing it at the intersection of several reference entities rather than owning descriptive master data itself.

The primary key, FA_MC_CONVERSION_HISTORY_PK, is defined on the composite of SET_OF_BOOKS_ID and BOOK_TYPE_CODE. The documented physical schema lists eleven columns in the 12.2.2 ETRM repository, and a unique index, FA_MC_CONVERSION_HISTORY_U1, mirrors the same two-column business key, confirming that one conversion history row exists per books and book-type combination.

Key Information Stored

The most significant columns fall into three groups: identifying keys, conversion control state, and conversion accounting results.

  • SET_OF_BOOKS_ID — Identifies the ledger (set of books) associated with the conversion; part of the composite primary key and business-key candidate.
  • BOOK_TYPE_CODE — Identifies the reporting book whose conversion is being tracked; the second half of the composite primary key and business-key candidate.
  • CONVERSION_STATUS — Tracks the current state of the conversion process for the book pairing.
  • PERIOD_COUNTER_START — The depreciation period from which conversion was initiated, joining to FA_DEPRN_PERIODS.
  • PERIOD_COUNTER_SELECTED — The depreciation period selected for conversion, also resolving against FA_DEPRN_PERIODS.
  • PERIOD_COUNTER_CONVERTED — The depreciation period actually converted, again keyed to FA_DEPRN_PERIODS.
  • FIXED_RATE_CONVERSION — Indicates whether a fixed exchange rate was applied during conversion.
  • TOTAL_ASSETS — The resulting total asset amount for the converted population, useful for reconciliation reporting.
  • EFC_STATUS and EFC_LAST_UPDATE_DATE — Status and timestamp for the Enterprise Financial Consolidation related processing associated with the conversion.
  • LAST_UPDATE_DATE — Standard audit column capturing when the row was last modified.

The surrogate-style composite primary key is the pair (SET_OF_BOOKS_ID, BOOK_TYPE_CODE); the unique index FA_MC_CONVERSION_HISTORY_U1 is essentially the same business key and can be treated as a candidate alternate key. The remaining columns carry descriptive and state attributes rather than key identity.

Common Use Cases and Queries

Typical usage centers on auditing and troubleshooting the multi-currency conversion of a reporting book, determining whether a period has been converted, and reconciling converted asset totals. A frequent query retrieves the latest conversion state for a given ledger and book:

  • SELECT conversion_status, period_counter_start, period_counter_selected, period_counter_converted, total_assets FROM fa_mc_conversion_history WHERE set_of_books_id = :books_id AND book_type_code = :book;
  • Identifying conversions still pending by filtering on CONVERSION_STATUS and EFC_STATUS.
  • Joining PERIOD_COUNTER_* columns to FA_DEPRN_PERIODS to translate counters into named accounting periods for reporting.
  • Comparing TOTAL_ASSETS across converted periods to validate completeness of the reporting book.

Related Objects

  • FA_BOOK_CONTROLS — joined on BOOK_TYPE_CODE; supplies the book definition and control attributes for the reporting book.
  • GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID; provides ledger identity and currency information.
  • FA_DEPRN_PERIODS — referenced three times via BOOK_TYPE_CODE with PERIOD_COUNTER_START, PERIOD_COUNTER_SELECTED, and PERIOD_COUNTER_CONVERTED, mapping conversion periods to named accounting periods.
  • FA_MC_CONVERSION_HISTORY_PK / FA_MC_CONVERSION_HISTORY_U1 — the primary key and unique index enforcing the books-plus-book-type identity.