Search Results fa_mc_adjustments




Overview
Explore in AI Chat

Overview

FA_MC_ADJUSTMENTS is an Oracle E-Business Suite Assets (OFA) table owned by the FA schema. Per the ETRM metadata, it "stores information to create adjustment journal entries in the reporting currency." It is a core component of Oracle Assets' Multi-Currency (MC) and reporting-currency functionality, which allows an enterprise to maintain a primary set of books alongside reporting sets of books or reporting currencies. When asset transactions — additions, adjustments, retirements, revaluations, and depreciation — are processed in the primary currency, Oracle Assets generates the corresponding amounts in each reporting currency. Where rounding, rate differences, or conversion timing create discrepancies between the primary-currency journal and the reporting-currency journal, FA_MC_ADJUSTMENTS holds the balancing adjustment line that reconciles the two.

While the table is not transaction-generating in the operational sense, it is critical to the accounting integrity of the reporting-currency ledger, since the rows it contains are consumed by the journal entry import process to produce offsetting entries in the reporting set of books. The heuristic Data Vault classification mined from its foreign-key structure is link, suggesting that FA_MC_ADJUSTMENTS is best modeled as a relationship table connecting asset transactions, distribution lines, books, and GL accounting flexfields rather than as an independent hub or a descriptive satellite.

Key Information Stored

The table contains 47 documented columns in release 12.2.2. The most operationally significant are:

The surrogate identifier corresponds to ADJUSTMENT_LINE_ID within the composite unique index; the business-key candidate is therefore (TRANSACTION_HEADER_ID, SET_OF_BOOKS_ID, ADJUSTMENT_LINE_ID).

Common Use Cases and Queries

Typical uses include reporting-currency reconciliation, troubleshooting unmatched GL journal entries, and audit of multi-currency adjustments. A common pattern identifies adjustments not yet interfaced to GL:

SELECT h.transaction_header_id, a.asset_number, m.adjustment_amount, m.debit_credit_flag
FROM fa_mc_adjustments m, fa_transaction_headers h, fa_additions_b a
WHERE m.transaction_header_id = h.transaction_header_id
AND m.asset_id = a.asset_id
AND m.set_of_books_id = :p_sob_id
AND m.je_header_id IS NULL;

Analysts also group by BOOK_TYPE_CODE and PERIOD_COUNTER_CREATED to trend adjustment volumes per book and period, or join to GL_CODE_COMBINATIONS to confirm the correct expense and asset clearing accounts were used for each reporting currency.

Related Objects

  • FA_TRANSACTION_HEADERS – joined on TRANSACTION_HEADER_ID; the parent transaction.
  • FA_ADDITIONS_B – joined on ASSET_ID; provides the asset master detail.
  • FA_DISTRIBUTION_HISTORY – joined on DISTRIBUTION_ID; supplies cost-center distribution.
  • FA_BOOK_CONTROLS – joined on BOOK_TYPE_CODE; identifies the asset book.
  • FA_DEPRN_PERIODS – joined on BOOK_TYPE_CODE with PERIOD_COUNTER_CREATED or PERIOD_COUNTER_ADJUSTED.
  • GL_CODE_COMBINATIONS – joined on CODE_COMBINATION_ID; supplies the accounting flexfield.
  • GL_JE_LINES – joined on JE_HEADER_ID and JE_LINE_NUM; confirms the generated GL entry.

Together these relationships position FA_MC_ADJUSTMENTS as the reconciliation bridge between Oracle Assets transactions and reporting-currency General Ledger postings.