Search Results terms_date




Overview
Explore in AI Chat

Overview

The view AP_INVOICES_ALL_MRC_V is a Multi-Reporting-Currency (MRC) view within the Oracle Payables (AP) module. It exposes invoice header information across multiple sets of books, allowing concurrent access to invoice data that has been converted into each reporting currency configured in a multi-org, multi-set-of-books environment. In Oracle EBS 12.1.1 and 12.2.2, MRC views are constructed by joining the primary-set-of-books invoice table with its associated reporting-set-of-books rows, thereby presenting a consolidated projection that includes the reporting currency amounts and exchange attributes alongside the transactional columns.

Because the view surfaces both the transactional (base) amounts and the corresponding reporting-currency amounts, it is the preferred source for cross-set-of-books reporting, general ledger reconciliation, and downstream integration extracts that must reflect every reporting currency in which the invoice was recorded. The ETRM metadata documents this object as "Not implemented in this database," indicating that the view definition is delivered as part of the standard AP schema but is instantiated in the customer database at runtime.

Underlying Base Objects

The ETRM metadata does not enumerate formal base objects. However, the view text reveals that it is defined by selecting from a primary alias, conventionally AP_INVOICES_ALL (referenced here through the MRC alias MC for the set-of-books-joined columns) and an alias B that supplies the POSTING_STATUS value, which is typically drawn from AP_INVOICE_PAYMENTS_ALL or the posting-status source. The columns SET_OF_BOOKS_ID, BASE_AMOUNT, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, and EXCHANGE_DATE are prefixed with MC, confirming they are supplied by the MRC join that links each invoice to its reporting-currency counterpart. The remaining columns are inherited from the primary invoice record.

Thus, the view behaves as a denormalized projection over the invoice header data and its MRC reporting rows, preserving every attribute needed for currency-aware reporting.

Key Columns

Common Use Cases and Queries

Typical usage includes approval-status reporting, multi-currency invoice analysis, and reconciliation of Payables to General Ledger across sets of books. A representative query filtering on approval state resembles:

  • SELECT invoice_id, invoice_num, set_of_books_id, invoice_amount, base_amount, approval_status, approval_description, payment_status_flag FROM ap_invoices_all_mrc_v WHERE org_id = :p_org_id AND approval_status = 'A';
  • Multi-currency aging: SELECT invoice_num, invoice_currency_code, base_amount, exchange_rate FROM ap_invoices_all_mrc_v WHERE set_of_books_id = :p_sob AND invoice_date BETWEEN :p_from AND :p_to;
  • Workflow approval audit: SELECT invoice_num, approval_status, approval_description, authorized_by FROM ap_invoices_all_mrc_v WHERE approval_status IN ('A','R','N');

When a user searches for wfapproval_status, this view is the appropriate reference because it consolidates the Payables approval columns with MRC currency context, enabling reporting that would otherwise require manual joins between the invoice header, its reporting-currency rows, and the workflow approval tables.