Search Results discount_original




Overview
Explore in AI Chat

Overview

AR_PAYMENT_SCHEDULES_ALL_MRC_V is a multi-reporting-currency (MRC) view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It exposes payment schedule information for Oracle Receivables transactions, combining the transactional (primary) currency columns of the base payment schedule with the reporting-currency equivalents maintained by the Multiple Reporting Currencies architecture. The "MRC" designation indicates that monetary amounts such as ACCTD_AMOUNT_DUE_REMAINING are drawn from the reporting-currency schedule, while operational and descriptive attributes originate from the primary schedule. The view supports the standard MRC practice of recording and reporting accounting entries in one or more reporting currencies in addition to the functional currency. As a reporting and integration object, it allows queries and downstream processes to retrieve payment schedule balances in a selected reporting currency without directly joining the underlying MRC table. The user search term "adjustment_id_last" maps to the ADJUSTMENT_ID_LAST column, which the view exposes for the most recent adjustment applied to a schedule line.

Underlying Base Objects

The documented view metadata identifies two referenced base objects, both accessed through synonyms:

  • AR_PAYMENT_SCHEDULES_ALL — the primary (functional or transaction currency) payment schedule table, aliased as PRIMARY in the view text. It supplies operational columns and the monetary amounts that are not reporting-currency specific.
  • AR_MC_PAYMENT_SCHEDULES — the multiple reporting currency payment schedule table, aliased as MC. It supplies the reporting-currency columns: EXCHANGE_RATE_TYPE, EXCHANGE_DATE, EXCHANGE_RATE, and ACCTD_AMOUNT_DUE_REMAINING, among others.

The view joins these objects on the shared payment schedule identity and transaction keys, presenting a single, denormalized row per schedule line for reporting-currency consumption. Because AR_MC_PAYMENT_SCHEDULES stores one row per reporting currency, the view is typically filtered by reporting currency context implied by the MRC setup.

Key Columns

Common Use Cases and Queries

This view is used in receivables reporting where reporting-currency balances are required, such as MRC-aware aging reports, reconciliation of accounting-currency receivables, and integration extracts that populate data warehouses or downstream subledgers.

  • Retrieving reporting-currency outstanding balances for a transaction.
  • Auditing the most recent adjustment applied to a schedule line via ADJUSTMENT_ID_LAST.
  • Reconciling primary versus accounting-currency amounts using the exchange rate columns.

A representative query follows:

SELECT payment_schedule_id,
       customer_trx_id,
       trx_number,
       acctd_amount_due_remaining,
       exchange_rate,
       adjustment_id_last,
       adjustment_amount_last,
       status
  FROM apps.ar_payment_schedules_all_mrc_v
 WHERE customer_trx_id = :p_customer_trx_id
   AND org_id = :p_org_id;

Because the view depends on MRC configuration, the reporting-currency row returned is determined by the active MRC setup, and results should be validated against the enabled reporting currencies in the instance.