Search Results fa_mc_mass_rates_pk

Overview

The FA_MC_MASS_RATES table is an Oracle E-Business Suite Assets (OFA) object that stores exchange rate information used during the mass additions process. Mass additions in Oracle Assets allow large volumes of asset records to be loaded from external sources — most commonly from Oracle Payables invoice distributions, Oracle Purchasing receipts, or interface feeds from feeder systems — and posted into the FA_ASSETS register. When a set of books uses a functional currency that differs from the transaction currency of an incoming addition, exchange rate information must be captured and retained so that cost conversions remain auditable at the row level. FA_MC_MASS_RATES fulfills that role: it holds the conversion data associated with each mass addition line, keyed to a specific mass addition and set of books. The table resides in the FA schema and is classified in the ETRM 12.2.2 physical schema with ten documented columns.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure suggests a link entity. The table does not merely describe a single business entity; it associates a mass addition with a set of books and carries descriptive rate attributes. Its surrogate-style composite primary key and dual foreign key references to FA_MASS_ADDITIONS reinforce an associative, relationship-oriented role.

Key Information Stored

The primary key of the table is FA_MC_MASS_RATES_PK, defined on the composite of MASS_ADDITION_ID and SET_OF_BOOKS_ID. Because the primary key is composite and drawn from foreign key columns rather than a system-generated sequence, these two columns serve as the effective business-key candidates; no separate single-column unique index is documented for this table.

• MASS_ADDITION_ID — identifies the mass addition line whose currency conversion is being recorded; part of the primary key and a foreign key to FA_MASS_ADDITIONS.
• SET_OF_BOOKS_ID — identifies the set of books (ledger) in which the addition is being processed; part of the primary key and a foreign key to GL_SETS_OF_BOOKS_11I.
• PARENT_MASS_ADDITION_ID — references the parent mass addition in FA_MASS_ADDITIONS, supporting hierarchical or grouped addition structures such as merged or split lines.
• FIXED_ASSETS_COST — the asset cost amount associated with the mass addition, expressed in the relevant currency context for conversion purposes.
• EXCHANGE_RATE — the conversion rate applied to translate the transaction amount into the functional currency of the set of books.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns capturing row creation and last modification metadata.

Common Use Cases and Queries

The table is most often queried during troubleshooting of mass additions postings, currency conversion discrepancies, and reconciliation between Payables and Assets. A typical query joins the table back to FA_MASS_ADDITIONS to review the rate applied to each addition:

• Verify conversion rates for a mass addition in a specific ledger: SELECT mass_addition_id, set_of_books_id, exchange_rate, fixed_assets_cost FROM fa.fa_mc_mass_rates WHERE set_of_books_id = :p_sob_id;
• Trace parent/child relationships among additions: SELECT mass_addition_id, parent_mass_addition_id FROM fa.fa_mc_mass_rates WHERE parent_mass_addition_id IS NOT NULL;
• Reconcile the sum of converted costs against posted asset costs for a period.
• Audit rate history for additions processed in a multi-currency ledger.

Related Objects

• FA_MASS_ADDITIONS — joined on MASS_ADDITION_ID and on PARENT_MASS_ADDITION_ID; the parent record of each rate row.
• GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID; supplies ledger and currency context.
• FA_ASSETS — downstream destination once additions are posted.
• FA_BOOK_CONTROLS — governs period and set-of-books processing state.
• GL_DAILY_RATES — the source of the rates recorded in EXCHANGE_RATE.