Results for “fa_mc_adjustments”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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:
- TRANSACTION_HEADER_ID – Foreign key to FA_TRANSACTION_HEADERS; identifies the parent asset transaction that generated this adjustment.
- SET_OF_BOOKS_ID – The reporting (or primary) set of books against which the adjustment posts.
- ADJUSTMENT_LINE_ID – The line-level identifier that, combined with TRANSACTION_HEADER_ID and SET_OF_BOOKS_ID, forms the unique business key FA_MC_ADJUSTMENTS_U1.
- BOOK_TYPE_CODE – Identifies the asset book; also a foreign key to FA_BOOK_CONTROLS and FA_DEPRN_PERIODS.
- ASSET_ID – References FA_ADDITIONS_B, tying the adjustment to the underlying asset.
- DISTRIBUTION_ID – References FA_DISTRIBUTION_HISTORY, providing the cost-center distribution of the adjustment.
- CODE_COMBINATION_ID – References GL_CODE_COMBINATIONS, supplying the accounting flexfield used for the adjustment.
- ADJUSTMENT_AMOUNT and ANNUALIZED_ADJUSTMENT – The reporting-currency adjustment value and its annualized equivalent.
- DEBIT_CREDIT_FLAG and ADJUSTMENT_TYPE – Characterize the direction and nature of the adjustment entry.
- JE_HEADER_ID and JE_LINE_NUM – Foreign keys to GL_JE_LINES confirming that the adjustment has been interfaced to General Ledger.
- PERIOD_COUNTER_CREATED and PERIOD_COUNTER_ADJUSTED – Reference FA_DEPRN_PERIODS, anchoring the adjustment to the correct depreciation period.
- SOURCE_TYPE_CODE, SOURCE_LINE_ID, SOURCE_DEST_CODE – Track the originating transaction and its destination, supporting reconciliation across books.
- CONVERTED_FLAG, DEPRN_OVERRIDE_FLAG, TRACK_MEMBER_FLAG – Control flags that record special processing states.
- GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1 through GLOBAL_ATTRIBUTE20 – The standard DFF extension columns.
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.
-
Stores information to create adjustment journal entries in the reporting currency
-
Stores information to create adjustment journal entries in the reporting currency
-
TABLE: FA.FA_MC_ADJUSTMENTS 12.2.2
-
TABLE: FA.FA_MC_ADJUSTMENTS 12.1.1