Results for “gain_loss”

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

Overview

AR_MC_RATE_ADJUSTMENTS is a Receivables (AR) module table in Oracle E-Business Suite, owned by the AR schema. It stores currency-related information about exchange rate adjustments for each reporting set of books. In the Oracle EBS architecture, this table functions as a multi-reporting-currencies companion to the base rate adjustment record, allowing a single exchange rate adjustment to be reflected in the currencies of multiple reporting sets of books. This is a key enabler of the Multi-Reporting Currencies (MRC) feature set, which allows an organization to maintain and report financial information in more than one currency while transacting in a single primary currency.

The table consists of nine documented columns and is scoped at the intersection of a set of books and a rate adjustment. The composite primary key AR_MC_RATE_ADJUSTMENTS_PK is defined over (SET_OF_BOOKS_ID, RATE_ADJUSTMENT_ID), and a unique index AR_MC_RATE_ADJUSTMENTS_U1 is defined over the inverse ordering (RATE_ADJUSTMENT_ID, SET_OF_BOOKS_ID). Based on the foreign-key structure—two parent references to AR_RATE_ADJUSTMENTS_ALL and GL_SETS_OF_BOOKS—the heuristic Data Vault classification for this object is a link, suggesting it can be modeled as an associative entity connecting a rate adjustment to a reporting set of books, carrying its own descriptive attributes.

Key Information Stored

The table captures both the pre-adjustment and post-adjustment currency attributes, enabling before-and-after comparison for reconciliation and audit purposes.

• SET_OF_BOOKS_ID – Identifies the reporting set of books for which the multi-currency adjustment is recorded; part of the composite primary key and a foreign key to GL_SETS_OF_BOOKS.
• RATE_ADJUSTMENT_ID – Identifies the underlying exchange rate adjustment; part of the composite primary key and a foreign key to AR_RATE_ADJUSTMENTS_ALL.
• NEW_EXCHANGE_RATE / OLD_EXCHANGE_RATE – The exchange rate after and before the adjustment, respectively.
• NEW_EXCHANGE_RATE_TYPE / OLD_EXCHANGE_RATE_TYPE – The rate type (for example, a user-defined or predefined rate type) associated with the new and old rates.
• NEW_EXCHANGE_DATE / OLD_EXCHANGE_DATE – The effective dates associated with the new and old exchange rates.
• GAIN_LOSS – The gain or loss amount resulting from the exchange rate adjustment, expressed in the reporting set of books currency.

The surrogate composite primary key is (SET_OF_BOOKS_ID, RATE_ADJUSTMENT_ID), while the unique index AR_MC_RATE_ADJUSTMENTS_U1 over (RATE_ADJUSTMENT_ID, SET_OF_BOOKS_ID) serves as a business-key candidate ensuring that exactly one multi-currency record exists per adjustment per set of books.

Common Use Cases and Queries

Typical scenarios include reconciling realized gain or loss on foreign-currency transactions across reporting books, auditing exchange rate changes applied to a specific adjustment, and reporting MRC-adjusted balances by set of books.

• Retrieving all reporting-book adjustments for a given rate adjustment:

  SELECT set_of_books_id, new_exchange_rate, old_exchange_rate,
         new_exchange_date, old_exchange_date, gain_loss
  FROM   ar.ar_mc_rate_adjustments
  WHERE  rate_adjustment_id = :p_rate_adjustment_id;

• Aggregating gain/loss by reporting set of books:

  SELECT set_of_books_id, SUM(gain_loss) total_gain_loss
  FROM   ar.ar_mc_rate_adjustments
  GROUP  BY set_of_books_id;

• Comparing old and new rates to identify significant revaluation movements for a period.

Related Objects

The following objects are most significant relative to this table, based on the documented foreign-key and key relationships:

• AR_RATE_ADJUSTMENTS_ALL – Parent table holding the base rate adjustment record; joined on RATE_ADJUSTMENT_ID.
• GL_SETS_OF_BOOKS – Defines the reporting set of books; joined on SET_OF_BOOKS_ID.
• AR_MC_RATE_ADJUSTMENTS_PK – Composite primary key constraint over (SET_OF_BOOKS_ID, RATE_ADJUSTMENT_ID).
• AR_MC_RATE_ADJUSTMENTS_U1 – Unique index over (RATE_ADJUSTMENT_ID, SET_OF_BOOKS_ID).
• Receivables MRC reporting views and concurrent programs – Consume this data when producing multi-currency Receivables reports and reconciliations.