Results for “ar_mc_adjustments”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_MC_ADJUSTMENTS (owner: AR) is a multi-currency companion table in Oracle Receivables that stores currency-related information about invoice adjustments for each reporting set of books. In an Oracle EBS 12.1.1 / 12.2.2 environment, adjustments recorded in AR_ADJUSTMENTS_ALL are stored in the functional currency of the operating unit's ledger. When multiple reporting (MRC) sets of books are configured, AR_MC_ADJUSTMENTS holds the corresponding accounting-currency amounts and posting information for each additional reporting ledger, allowing the same adjustment to be reported accurately across all sets of books without duplicating the underlying transactional record.

Under a heuristic Data Vault classification mined from its foreign-key structure, the table is best modeled as a link. Its composite primary key joins an adjustment to a ledger, resolving a many-to-many relationship between AR_ADJUSTMENTS_ALL and GL_SETS_OF_BOOKS, and it also carries a referenced posting-control entity. It therefore serves as a relationship/association record rather than a pure hub or a descriptive satellite.

Key Information Stored

• ADJUSTMENT_ID — Part of the primary key; foreign key to AR_ADJUSTMENTS_ALL, identifying the underlying invoice adjustment.
• SET_OF_BOOKS_ID — Part of the primary key; foreign key to GL_SETS_OF_BOOKS, identifying the reporting set of books (reporting ledger) for which the currency information is stored.
• POSTING_CONTROL_ID — Foreign key to AR_POSTING_CONTROL, linking the multi-currency adjustment to its posting-control record that governs accounting and posting status.
• GL_POSTED_DATE — The date the multi-currency adjustment amount was posted to the General Ledger for the associated reporting set of books.
• ACCTD_AMOUNT — The accounted (reporting-currency) amount of the adjustment for the reporting set of books, distinguished from the functional-currency amount held on AR_ADJUSTMENTS_ALL.
• LAST_UPDATE_DATE — Standard EBS audit column recording the most recent modification timestamp.
• LAST_UPDATED_BY — Standard EBS audit column recording the user or process responsible for the last change.

The surrogate-style uniqueness is enforced by the primary key constraint AR_MC_ADJUSTMENTS_PK and the unique index AR_MC_ADJUSTMENTS_U1, both defined on (ADJUSTMENT_ID, SET_OF_BOOKS_ID). This composite is the business-key candidate: no adjustment may have more than one multi-currency row per set of books. The table is documented with seven columns, so the key above is exhaustive rather than selectively sampled.

Common Use Cases and Queries

Typical scenarios include multi-currency adjustment reconciliation, reporting-ledger proofing, and general-ledger posting audits. The most frequent query pattern joins the table back to AR_ADJUSTMENTS_ALL to compare functional retained amounts with accounted amounts.

• Reconciling accounted adjustment amounts per reporting ledger:

  SELECT m.ADJUSTMENT_ID, m.SET_OF_BOOKS_ID, m.ACCTD_AMOUNT
  FROM   AR_MC_ADJUSTMENTS m
  WHERE  m.ADJUSTMENT_ID = :adjustment_id;

• Identifying unposted multi-currency adjustments by inspecting GL_POSTED_DATE for nulls or by joining to the AR_POSTING_CONTROL record via POSTING_CONTROL_ID.
• Multi-currency adjustment reports that aggregate ACCTD_AMOUNT by SET_OF_BOOKS_ID for period close and intercompany analysis.
• Audit extraction filtering on LAST_UPDATE_DATE and LAST_UPDATED_BY to track changes made during a given period.

Related Objects

• AR_ADJUSTMENTS_ALL — Parent table; joined on AR_MC_ADJUSTMENTS.ADJUSTMENT_ID = AR_ADJUSTMENTS_ALL.ADJUSTMENT_ID. Supplies the base adjustment definition.
• GL_SETS_OF_BOOKS — Joined on AR_MC_ADJUSTMENTS.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID. Provides the reporting ledger context.
• AR_POSTING_CONTROL — Joined on AR_MC_ADJUSTMENTS.POSTING_CONTROL_ID = AR_POSTING_CONTROL.POSTING_CONTROL_ID. Governs posting and accounting status.
• GL_JE_LINES / GL_IMPORT_REFERENCES — Used indirectly to trace posted accounted amounts back to the journal entries generated from the adjustment.
• AR_MC_CASH_RECEIPTS and AR_MC_CUSTOMER_TRX — Parallel multi-currency tables following the same reporting-set-of-books design pattern for other Receivables entities.