Search Results fa_mc_conversion_rates_pk

Overview

FA_MC_CONVERSION_RATES is a table in the Oracle Assets (OFA) module, owned by the FA schema. It stores the exchange rate information required to convert asset values from a primary book to a reporting (multicurrency) book. In Oracle EBS 12.1.1 and 12.2.2, this table acts as the bridge between the transactional asset record and the reporting book currency, holding the specific conversion rate and basis applied to each asset for each reporting book.

Because it carries both the rate and the converted cost figures tied to a specific asset, book, and set of books, its heuristic Data Vault classification is a link, connecting the asset (hub) to the reporting book configuration. This classification is a modeling suggestion based on the foreign key structure and the composite nature of the key, rather than a documented Oracle attribute.

Key Information Stored

The table's primary key, FA_MC_CONVERSION_RATES_PK, is composed of three columns: ASSET_ID, SET_OF_BOOKS_ID, and BOOK_TYPE_CODE. A unique index, FA_MC_CONVERSION_RATES_U1, is defined over the same three columns (SET_OF_BOOKS_ID, BOOK_TYPE_CODE, ASSET_ID), confirming this triplet as the business-key candidate. The nine documented columns are:

• ASSET_ID — identifier of the asset being converted; joins to FA_ADDITIONS_B.
• SET_OF_BOOKS_ID — the reporting set of books; joins to GL_SETS_OF_BOOKS_11I.
• BOOK_TYPE_CODE — the reporting book type; joins to FA_BOOK_CONTROLS and FA_DEPRN_PERIODS.
• STATUS — status indicator for the conversion record.
• COST — the converted asset cost in the reporting book currency.
• PRIMARY_CUR_COST — the original asset cost in the primary book currency, used as the conversion source.
• EXCHANGE_RATE — the rate applied to convert primary currency values to reporting currency.
• CONVERSION_BASIS — the basis or method used for the currency conversion.
• LAST_PERIOD_COUNTER — the depreciation period counter linked to FA_DEPRN_PERIODS, indicating the latest period reflected.

Common Use Cases and Queries

Typical scenarios include verifying conversion rates used for reporting-book asset costs, reconciling primary versus reporting book cost, and auditing the conversion basis applied to a given asset population. A representative query retrieves the conversion detail for an asset across its reporting books:

• SELECT asset_id, set_of_books_id, book_type_code, exchange_rate, conversion_basis, cost, primary_cur_cost FROM fa_mc_conversion_rates WHERE asset_id = :asset_id;
• Reporting by book: filter on book_type_code and set_of_books_id to list all converted assets for a reporting book.
• Rate audit: group by exchange_rate and conversion_basis to confirm consistent conversion across assets in a set of books.

These patterns support period-end reconciliation, reporting-book cost rollups, and validation that cost equals the product of primary_cur_cost and exchange_rate under the documented basis.

Related Objects

The foreign key relationships and key columns tie this table to several core Assets and General Ledger objects:

• FA_ADDITIONS_B — joined on ASSET_ID; supplies asset identity and descriptive attributes.
• FA_BOOK_CONTROLS — joined on BOOK_TYPE_CODE; defines book-level control settings.
• FA_DEPRN_PERIODS — joined on BOOK_TYPE_CODE and LAST_PERIOD_COUNTER; identifies the depreciation period.
• GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID; identifies the reporting set of books and currency.
• FA_BOOKS — the primary book asset cost table, commonly compared against converted values held here.

Together these objects allow the conversion record to be resolved to its asset, reporting book, period, and set of books context.