Search Results ap_mc_invoices




Overview
Explore in AI Chat

Overview

AP_MC_INVOICES is a Multi-Reporting Currency (MRC) shadow table owned by the AP (Payables) schema in Oracle E-Business Suite. It stores detailed invoice records expressed in the MRC-defined reporting currency, mirroring the transactional data held in the primary AP_INVOICES_ALL table but converted into the reporting set of books. In a multi-organization, multi-set-of-books environment, Oracle Payables uses MRC to maintain accounting records across multiple functional currencies. While transactional tables such as AP_INVOICES_ALL capture amounts in the ledger's functional currency, AP_MC_INVOICES preserves the corresponding reporting-currency figures, enabling consolidated reporting and cross-ledger analysis without repeated currency conversion at query time.

The table is documented as VALID within the AP product for releases 12.1.1 and 12.2.2, and is identified by the primary key AP_MC_INVOICES_PK, composed of INVOICE_ID and SET_OF_BOOKS_ID. Based on the heuristic Data Vault classification mined from the foreign-key structure, this object is treated as a standalone table. In Data Vault modeling terms, this suggests the object can be modeled independently, with INVOICE_ID and SET_OF_BOOKS_ID serving as the composite business key that links back to its source invoice entity.

Key Information Stored

The documented physical schema for AP_MC_INVOICES contains six columns. The most important of these are summarized below.

  • INVOICE_ID — The invoice identifier that joins this MRC record to the base invoice in AP_INVOICES_ALL. It forms part of the composite primary key and the unique index AP_MC_INVOICES_U1.
  • SET_OF_BOOKS_ID — The reporting set of books (ledger) under which the converted amounts are held. It is the second component of the composite primary key and identifies the MRC reporting context.
  • BASE_AMOUNT — The invoice amount expressed in the reporting (MRC) currency, providing the converted value used for consolidated reporting.
  • EXCHANGE_RATE — The rate applied to convert the transaction from its functional currency into the reporting currency.
  • EXCHANGE_RATE_TYPE — The rate type (for example, Spot, Corporate, or User-defined) governing the conversion used for this record.
  • EXCHANGE_DATE — The date on which the exchange rate was effective, determining the conversion basis for the reporting-currency amount.

The composite primary key (INVOICE_ID, SET_OF_BOOKS_ID) is mirrored by the unique index AP_MC_INVOICES_U1, making this pair the documented business-key candidate. The surrogate nature of the key means individual rows are uniquely identified by the combination of invoice and reporting ledger, rather than by a single generated identifier.

Common Use Cases and Queries

AP_MC_INVOICES is typically queried to reconcile reporting-currency invoice balances against the functional-currency figures in AP_INVOICES_ALL, and to produce consolidated Payables reports across multiple sets of books. A common pattern joins the MRC table to its base invoice table on INVOICE_ID and SET_OF_BOOKS_ID to compare converted and source amounts:

  • Reporting-currency invoice registers filtered by SET_OF_BOOKS_ID.
  • Exchange rate and rate-type validation for audit and revaluation checks.
  • Period-end consolidation of invoice amounts across ledgers.
  • Reconciliation between BASE_AMOUNT and the functional amount in AP_INVOICES_ALL.

A representative query joins the two tables to surface reporting-currency amounts alongside the base invoice:

SELECT m.invoice_id, m.set_of_books_id, m.base_amount, m.exchange_rate, m.exchange_rate_type, m.exchange_date FROM ap.ap_mc_invoices m WHERE m.set_of_books_id = :ledger_id;

Related Objects

The following objects are most significant in relation to AP_MC_INVOICES:

  • AP_INVOICES_ALL — joins on INVOICE_ID to provide the functional-currency invoice detail.
  • AP_MC_INVOICE_DISTS / MRC distribution tables — hold the corresponding reporting-currency invoice distributions.
  • AP_MC_INVOICE_LINES — the MRC line-level records associated with the same INVOICE_ID and SET_OF_BOOKS_ID.
  • AP_SETS / ledger definitions — relate through SET_OF_BOOKS_ID to identify the reporting ledger.
  • GL_DAILY_RATES — provides the rate referenced by EXCHANGE_RATE_TYPE and EXCHANGE_DATE.
  • AP_INVOICES — the base invoice view over AP_INVOICES_ALL.

The composite join columns (INVOICE_ID, SET_OF_BOOKS_ID) form the linkage pathway between this MRC table and its parent invoice and ledger entities.