Search Results ar_receivable_apps_mrc_v




Overview
Explore in AI Chat

Overview

AR_RECEIVABLE_APPS_MRC_V is a Multi-Reporting Currency (MRC) view owned by the APPS schema in Oracle E-Business Suite Receivables. It presents receivable application data across multiple sets of books simultaneously, allowing a single query to return application amounts expressed both in the primary functional currency and in the reporting currencies defined by the MRC architecture. The view is registered as VALID and is exposed to reporting, integration, and reconciliation processes that must compare accounting entries between a primary ledger and its associated reporting ledgers.

The view is central to any analysis of how cash receipts, on-account credits, and adjustments are applied against transactions across ledgers. Because Oracle EBS 12.1.1 and 12.2.2 both support the MRC model for multi-currency reporting, this view remains a stable interface for cross-ledger queries. The presence of the LINE_APPLIED column makes it particularly relevant to users investigating line-level application activity, such as matching a receipt to a specific transaction line.

Underlying Base Objects

The view is defined primarily over the synonym AR_MC_RECEIVABLE_APPS, which is the MRC-enabled counterpart of the base application table. The base object AR_RECEIVABLE_APPLICATIONS supplies the primary ledger columns (aliased as PRIMARY in the view definition), while the MC alias contributes set-of-books-specific and accounting columns. Key columns drawn from the MC source include SET_OF_BOOKS_ID, GL_POSTED_DATE, POSTING_CONTROL_ID, ACCTD_AMOUNT_APPLIED_FROM, ACCTD_AMOUNT_APPLIED_TO, ACCTD_EARNED_DISCOUNT_TAKEN, and ACCTD_UNEARNED_DISCOUNT_TAKEN.

The join links primary application rows to their reporting-currency counterparts, producing one row per application per set of books. This structure mirrors the standard MRC pattern where transactional columns repeat for each reporting ledger, and accounting columns are stored specifically for that ledger.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling applied amounts between ledgers, reporting line-level application detail, and auditing accounting entries for discounts and on-account applications. The following query lists applications against a specific transaction line across all reporting ledgers:

SELECT ra.receivable_application_id,
       ra.set_of_books_id,
       ra.line_applied,
       ra.amount_applied,
       ra.acctd_amount_applied_to,
       ra.gl_date
FROM   apps.ar_receivable_apps_mrc_v ra
WHERE  ra.applied_customer_trx_line_id = :p_line_id
ORDER BY ra.set_of_books_id, ra.gl_date;

A second scenario compares entered versus accounted application amounts for a given ledger:

SELECT ra.customer_trx_id,
       ra.line_applied,
       SUM(ra.amount_applied)          entered_total,
       SUM(ra.acctd_amount_applied_to) accounted_total
FROM   apps.ar_receivable_apps_mrc_v ra
WHERE  ra.set_of_books_id = :p_sob_id
GROUP BY ra.customer_trx_id, ra.line_applied;

Because the view aggregates primary and reporting-currency columns, it is well suited to period-end close reporting, subledger-to-general-ledger reconciliation, and custom extracts where multi-ledger visibility of receivable applications is required.