Search Results ap_checks_all_mrc_v

Overview

AP_CHECKS_ALL_MRC_V is a multi-organization (MULTI-ORG) reporting view in the Oracle Payables (AP) module. The suffix "MRC" denotes Multiple Reporting Currencies, an Oracle EBS architecture in which each transaction carries a primary-set-of-books amount alongside one or more reporting-set-of-books equivalents. This view exposes payment and check information together with the reporting-currency columns required to reconcile or report those payments in a currency other than the functional currency of the primary ledger.

Within Oracle EBS 12.1.1 and 12.2.2, MRC views are typically layered over an underlying "ALL" view such as AP_CHECKS_ALL_V, joining the transaction to its MRC/converted-amount counterpart. Because it carries an ORG_ID column, the view is multi-org secured and, when queried through the standard Oracle Applications security model, returns only the operating units accessible to the current responsibility. It is intended for inquiry, reporting, and integration scenarios, not for direct DML.

The ETRM metadata specifically notes "Not implemented in this database," meaning the view definition is documented but was not present in the source environment at the time of extraction. The view text below should therefore be treated as the authoritative structural reference.

Underlying Base Objects

The documented metadata does not enumerate referenced base objects. The view text, however, reveals the primary source table via the alias MC, which supplies the MRC-specific columns such as MC.CHECK_ID, MC.CLEARED_BASE_AMOUNT, MC.CLEARED_EXCHANGE_RATE, MC.CLEARED_EXCHANGE_DATE, MC.CLEARED_EXCHANGE_RATE_TYPE, MC.EXCHANGE_RATE, MC.EXCHANGE_DATE, MC.EXCHANGE_RATE_TYPE, and MC.BASE_AMOUNT. These aliased columns confirm that AP_CHECKS_ALL_MRC_V joins the standard AP_CHECKS_ALL columns with a reporting-currency table (the check MRC table) keyed on CHECK_ID.

Practically, the view can be understood as AP_CHECKS_ALL_V joined to AP_CHECKS_ALL_MRC (reporting-currency rows) on CHECK_ID. The non-aliased columns — CHECK_NUMBER, CHECK_DATE, AMOUNT, VENDOR_NAME, STATUS_LOOKUP_CODE, CLEARED_AMOUNT, CLEARED_DATE, and the descriptive GLOBAL_ATTRIBUTE and ATTRIBUTE columns — come from the base check entity, while the MC-prefixed columns carry the reporting-currency conversion values.

Key Columns

• CLEARED_EXCHANGE_RATE_TYPE — the exchange rate type (for example, Corporate or Spot) applied when the payment was cleared in the reporting currency. This is the column most relevant to the user's search term and pairs with CLEARED_EXCHANGE_RATE and CLEARED_EXCHANGE_DATE.
• EXCHANGE_RATE_TYPE, EXCHANGE_RATE, EXCHANGE_DATE — the conversion attributes recorded at payment time, distinct from the clearing attributes above.
• CLEARED_BASE_AMOUNT, BASE_AMOUNT — reporting-currency equivalents of the cleared amount and the payment amount.
• CHECK_ID, CHECK_NUMBER, CHECK_DATE, AMOUNT, CURRENCY_CODE — core payment identification and primary-currency amount.
• STATUS_LOOKUP_CODE, VOID_DATE, STOPPED_AT, RELEASED_AT, RECONCILIATION_BATCH_ID — payment lifecycle and reconciliation state.
• ORG_ID, VENDOR_ID, VENDOR_SITE_ID — multi-org and supplier identifiers supporting secured reporting.

Common Use Cases and Queries

Typical uses include reconciling cleared payments in a reporting currency, auditing which exchange rate type was applied at clearing, and extracting payment data for treasury or cash-management reporting. Because MRC columns populate only for reporting books, filters on CLEARED_EXCHANGE_RATE_TYPE are meaningful only where reporting-currency rows exist.

Sample query listing cleared payments and their clearing exchange attributes:

• SELECT check_number, check_date, currency_code, cleared_amount, cleared_exchange_rate, cleared_exchange_rate_type, cleared_exchange_date, cleared_base_amount FROM ap_checks_all_mrc_v WHERE cleared_date IS NOT NULL AND org_id = :p_org_id ORDER BY check_date DESC;
• SELECT check_number, vendor_name, exchange_rate_type, cleared_exchange_rate_type FROM ap_checks_all_mrc_v WHERE cleared_exchange_rate_type = 'Corporate';

As with all MRC views, results are governed by MO: Operating Unit and reporting-currency security, and the view should be accessed read-only.