Search Results fa_mc_books_rates




Overview
Explore in AI Chat

Overview

The FA_MC_BOOKS_RATES table is a core data object within the Oracle E-Business Suite Fixed Assets (OFA) module, specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for storing exchange rate information required for multi-currency accounting. In a multi-currency environment, asset transactions (such as additions, adjustments, and retirements) may be entered in a currency different from the functional currency of the asset book. This table captures the precise conversion rates applied at the time of each transaction, ensuring accurate and auditable translation of asset costs, depreciation, and other financial amounts into the book's functional currency for financial reporting and ledger posting.

Key Information Stored

The table's structure is designed to link exchange rates to specific asset transactions and books. Its primary key uniquely identifies a record by the combination of SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID, and INVOICE_TRANSACTION_ID. Critical columns include SET_OF_BOOKS_ID, which links to the GL_SETS_OF_BOOKS table to identify the target ledger; BOOK_TYPE_CODE, referencing the specific asset book; and ASSET_ID, identifying the individual asset. The TRANSACTION_HEADER_ID and INVOICE_TRANSACTION_ID columns are foreign keys to FA_TRANSACTION_HEADERS and FA_INVOICE_TRANSACTIONS, respectively, providing the transactional context. The table stores the exchange rate type (e.g., Corporate, Spot) and the actual conversion rate applied for the transaction date.

Common Use Cases and Queries

This table is essential for audit trails, reconciliation, and generating multi-currency financial reports. A common use case is tracing the cost of an asset in its transaction currency versus its functional currency. For instance, to review the exchange rates applied to all additions for a specific asset, one might execute a query joining FA_MC_BOOKS_RATES to FA_TRANSACTION_HEADERS and FA_ADDITIONS. Another critical scenario is period-end reconciliation, where accountants verify that the translated asset balances in the general ledger align with the fixed assets subledger, using the rates stored in this table. Support personnel may query it to diagnose discrepancies in asset valuations or depreciation expenses following currency revaluations.

Related Objects

As indicated by its foreign key constraints, FA_MC_BOOKS_RATES has integral relationships with several key Fixed Assets and General Ledger tables. It is directly linked to FA_ADDITIONS_B for asset details, FA_BOOK_CONTROLS for book configuration, and FA_TRANSACTION_HEADERS for the overarching transaction record. The link to FA_INVOICE_TRANSACTIONS connects the rate to the original invoice line. Its most significant financial system relationship is with GL_SETS_OF_BOOKS, tethering the asset transaction's currency conversion to a specific ledger. This table is primarily written to by the asset transaction processing engine and is read by standard multi-currency reports and the interface programs that create accounting entries for the general ledger.