Search Results fa_mc_conversion_rates_u1

Overview

FA.FA_MC_CONVERSION_RATES is a transactional table in the Oracle E-Business Suite Fixed Assets (FA) module that stores multi-currency (MC) conversion information for individual assets. Its primary purpose is to hold the converted cost amounts and associated exchange rates that are used when an asset is tracked in a reporting currency distinct from its primary (functional) currency. This mechanism supports the multi-currency revaluation and reporting requirements that arise when an organization's set of books needs to present asset balances in more than one currency.

From a Data Vault modeling perspective, the metadata heuristic classifies this object as a link. This classification reflects the table's role in associating an asset, a set of books, and a book type, effectively acting as a relationship or transaction record that connects several business entities rather than storing only descriptive attribute history. Each row represents a multi-currency conversion snapshot tied to a specific asset and its associated accounting context.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, confirming its status as transactional data rather than reference or setup data. Its FND design data identifier is OFA.FA_MC_CONVERSION_RATES.

Key Information Stored

The table contains nine documented columns. The most significant columns are described below.

• ASSET_ID (NUMBER, 15) — Identifies the asset whose multi-currency conversion is being recorded. This is a foreign key to FA_ADDITIONS_B.
• SET_OF_BOOKS_ID (NUMBER, 15) — Identifies the set of books (ledger) in which the conversion applies. Foreign key to GL_SETS_OF_BOOKS_11I.
• BOOK_TYPE_CODE (VARCHAR2, 15) — Identifies the depreciation book type. Foreign key to FA_BOOK_CONTROLS and FA_DEPRN_PERIODS.
• STATUS — Represents the conversion status of the record.
• COST — The cost amount recorded for the conversion, typically in the foreign currency.
• PRIMARY_CUR_COST — The cost amount expressed in the primary (functional) currency.
• EXCHANGE_RATE — The exchange rate applied to convert between the primary and reporting currencies.
• CONVERSION_BASIS — The basis or method used for the currency conversion.
• LAST_PERIOD_COUNTER (NUMBER, 15) — A counter that tracks the last period processed for the conversion.

The documented unique index FA_MC_CONVERSION_RATES_U1 spans SET_OF_BOOKS_ID, BOOK_TYPE_CODE, and ASSET_ID, making this combination the business-key candidate. The primary key FA_MC_CONVERSION_RATES_PK is defined over ASSET_ID, SET_OF_BOOKS_ID, and BOOK_TYPE_CODE. Note that the surrogate primary key and the unique index constraint together enforce the same three-column combination, ensuring that each asset has at most one conversion row per book type and set of books.

Common Use Cases and Queries

Typical use cases include reconciling multi-currency asset balances, verifying exchange rates applied to conversions, and reporting converted costs by asset or by book. A common query pattern retrieves all conversion rows for a given asset across its book types:

• SELECT asset_id, set_of_books_id, book_type_code, cost, primary_cur_cost, exchange_rate FROM fa.fa_mc_conversion_rates WHERE asset_id = :asset_id;
• Joining to FA_ADDITIONS_B to obtain asset descriptions and to FA_BOOK_CONTROLS to validate the book context.
• Filtering by CONVERSION_BASIS or STATUS to audit which records have completed conversion processing.

Because the table is keyed on asset and book, reports that compare primary-currency cost against converted cost can be built directly from COST and PRIMARY_CUR_COST columns, using EXCHANGE_RATE to explain the difference.

Related Objects

The following tables are the most significant related objects, based on the documented foreign key relationships and dependencies.

• FA_ADDITIONS_B — joined on ASSET_ID; holds the master asset definition.
• FA_BOOK_CONTROLS — joined on BOOK_TYPE_CODE; defines depreciation book parameters.
• GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID; defines the set of books.
• FA_DEPRN_PERIODS — joined on BOOK_TYPE_CODE; provides depreciation period context for LAST_PERIOD_COUNTER.
• APPS.FA_MC_CONVERSION_RATES — the synonym or view layer through which the table is typically accessed from the APPS schema.

These relationships confirm that FA_MC_CONVERSION_RATES functions as a link between asset, ledger, and book entities within the Fixed Assets multi-currency subsystem.