Search Results fa_mc_adjustments_n4

Overview

FA.FA_MC_ADJUSTMENTS is a transaction-level accounting table in the Oracle E-Business Suite Fixed Assets module. Its name reflects its function: it stores multi-currency (MC) adjustment lines generated when Oracle Assets must reconcile, translate, or revalue asset balances between the functional currency of a book and a reporting currency. Each row represents a single debit or credit adjustment line that feeds the Asset subledger journal, carrying the accounting flexfield, the amount, the originating source transaction, and the depreciation period to which the adjustment belongs.

In Oracle EBS 12.1.1 and 12.2.2, the table resides in the FA schema, is owned at design level by OFA under the FND Design Data entry OFA.FA_MC_ADJUSTMENTS, and is stored in the APPS_TS_TX_DATA tablespace with PCTFREE 10. Its transaction-nature and its position between originating business events (asset additions, transaction headers, distribution history) and the general ledger identifies it as an associative structure. Under the heuristic Data Vault classification mined from its foreign key structure, it is best modeled as a link — it resolves the many-to-many relationships among transaction headers, assets, distributions, books, and GL journals, rather than acting as a standalone hub of business keys. Indexes are held in APPS_TS_TX_IDX.

Key Information Stored

The table contains 47 documented columns. Rather than enumerating them all, the following are the most operationally significant:

• TRANSACTION_HEADER_ID, SET_OF_BOOKS_ID, ADJUSTMENT_LINE_ID — The three columns forming the unique index FA_MC_ADJUSTMENTS_U1 (type NORMAL, uniqueness UNIQUE). This composite is the business-key candidate; it guarantees that an adjustment line is unique within a transaction header and its set of books. The user query on the index name confirms this is the primary discovery path.
• ADJUSTMENT_AMOUNT and ANNUALIZED_ADJUSTMENT — The monetary values posted and the annualized equivalent used for depreciation recalculation.
• DEBIT_CREDIT_FLAG — Determines the sign of the posting; essential for journal reconstruction.
• CODE_COMBINATION_ID — The GL accounting flexfield to which the adjustment posts.
• ASSET_ID, BOOK_TYPE_CODE, DISTRIBUTION_ID — Identify the affected asset, the depreciation book, and the distribution line.
• SOURCE_TYPE_CODE and ADJUSTMENT_TYPE — Classify the origin and nature of the adjustment (e.g., revaluation, transfer, translation).
• JE_HEADER_ID and JE_LINE_NUM — The GL journal header and line that this adjustment created.
• PERIOD_COUNTER_CREATED and PERIOD_COUNTER_ADJUSTED — Define the period in which the row was created and the period being adjusted.
• ASSET_INVOICE_ID — Links to the invoice-based addition that triggered the adjustment.
• CONVERTED_FLAG, DEPRN_OVERRIDE_FLAG, TRACK_MEMBER_FLAG, SOURCE_DEST_CODE, INSERTION_ORDER — Control and audit columns governing conversion, depreciation override behaviour, member tracking, and processing sequence.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS who-columns used for audit and change tracking.

Common Use Cases and Queries

Because this table is the subledger source for multi-currency asset adjustments, it is commonly queried for reconciliation of FA to GL, for period-close diagnostics, and for revaluation reporting.

• Reconcile adjustments to a GL journal. Join on JE_HEADER_ID and JE_LINE_NUM to GL_JE_LINES, filtered by SET_OF_BOOKS_ID.
• Asset-level adjustment history. The index FA_MC_ADJUSTMENTS_N2 (ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER_CREATED, SET_OF_BOOKS_ID) supports a direct query of everything adjusted for an asset in a book by period.
• Book/period reporting. FA_MC_ADJUSTMENTS_N4 (BOOK_TYPE_CODE, PERIOD_COUNTER_CREATED, SET_OF_BOOKS_ID) supports extracts of all adjustments for a book in a given depreciation period.
• Distribution-level and journal-level lookups. N1 covers DISTRIBUTION_ID with book and period; N3 covers JE_HEADER_ID/JE_LINE_NUM.

A representative pattern: select TRANSACTION_HEADER_ID, ASSET_ID, ADJUSTMENT_AMOUNT, DEBIT_CREDIT_FLAG, JE_HEADER_ID from FA_MC_ADJUSTMENTS where BOOK_TYPE_CODE = :book and PERIOD_COUNTER_CREATED = :pc and SET_OF_BOOKS_ID = :sob. For best performance, always supply the leading column of the applicable index.

Related Objects

The foreign keys documented for this table identify its principal dependencies and join columns:

• FA.FA_TRANSACTION_HEADERS via TRANSACTION_HEADER_ID — the originating transaction batch.
• FA.FA_ADDITIONS_B via ASSET_ID — the asset to which the adjustment relates.
• FA.FA_DISTRIBUTION_HISTORY via DISTRIBUTION_ID — the distribution line being adjusted.
• FA.FA_BOOK_CONTROLS and FA.FA_DEPRN_PERIODS via BOOK_TYPE_CODE — book definition and open/closed depreciation period context.
• GL.GL_CODE_COMBINATIONS via CODE_COMBINATION_ID — the accounting flexfield used for posting.
• GL.GL_JE_LINES via JE_HEADER_ID — the downstream journal entry created by the adjustment.

In practice, FA_ADDITIONS_B, FA_TRANSACTION_HEADERS, and FA_BOOK_CONTROLS are the most frequently joined parents, while GL_JE_LINES provides the GL-side reconciliation anchor for period-close reporting.