Search Results amount_variance

Overview

The AP_INVOICE_DISTS_ALL_MRC_V view belongs to the Oracle Payables (AP) module and is classified as a Multi-Reporting Currency (MRC) view. In Oracle EBS 12.1.1 and 12.2.2, MRC functionality allows a single transaction to be accounted for and reported in multiple reporting currencies within a single ledger set. This view presents invoice distribution data — the accounting line detail for payables invoices — with amounts expressed in the reporting currencies configured for the operating unit. It is a reporting and integration construct rather than a base transaction table, and the ETRM metadata records it as "Not implemented in this database," meaning it is not created as a permanent database object in that particular environment unless MRC is enabled and the relevant patch/setup is applied.

Underlying Base Objects

The documented view text references two principal aliases: B and MC. Alias B supplies invoice-distribution-level attributes such as ACCOUNTING_DATE, PERIOD_NAME, MATCH_STATUS_FLAG, POSTED_FLAG, tax indicators, scheduling and encumbrance fields, and descriptive flexfield ATTRIBUTE1 through ATTRIBUTE15. Alias MC supplies multi-currency columns including DIST_CODE_COMBINATION_ID (surfaced from MC.DIST_CODE_COMBINATION_ID), SET_OF_BOOKS_ID, AMOUNT, BASE_AMOUNT, POSTED_AMOUNT, POSTED_BASE_AMOUNT, AMOUNT_TO_POST, BASE_AMOUNT_TO_POST, and exchange-rate attributes such as EXCHANGE_DATE, EXCHANGE_RATE, and EXCHANGE_RATE_TYPE. The ETRM record lists no documented base objects explicitly, indicating the view joins a base distribution table to an MRC shadow table (typically an *_MRC companion) on the distribution line and invoice identifiers.

Key Columns

• DIST_CODE_COMBINATION_ID — The distribution-line accounting flexfield combination; this is the column users search for under the term mrc_dist_code_combination_id, representing the reporting-currency code combination for the distribution.
• INVOICE_ID and DISTRIBUTION_LINE_NUMBER — Together identify the specific invoice distribution line.
• SET_OF_BOOKS_ID — The ledger/books context in which the MRC amounts are recorded.
• AMOUNT, BASE_AMOUNT, POSTED_AMOUNT, POSTED_BASE_AMOUNT, AMOUNT_TO_POST, BASE_AMOUNT_TO_POST — Distribution amounts in entered and reporting/base currency terms.
• ACCOUNTING_DATE and PERIOD_NAME — The accounted date and GL period for the distribution.
• ACCRUAL_POSTED_FLAG, CASH_POSTED_FLAG, POSTED_FLAG — Posting-status indicators for accrual and cash accounting.
• ACCTS_PAY_CODE_COMBINATION_ID, RATE_VAR_CODE_COMBINATION_ID, PRICE_VAR_CODE_COMBINATION_ID — Corresponding accounting combinations for liability, rate variance, and price variance lines.

Common Use Cases and Queries

Typical use cases include MRC-aware payables reporting, reconciling invoice distributions to General Ledger in multiple reporting currencies, and integration extracts that must retrieve accounting combinations for each reporting currency. A representative query joining the view to invoice headers appears below.

• Querying distributions for a given invoice and reporting ledger.
• Retrieving the MRC distribution code combination for posting validation.
• Extracting posted amounts by accounting period for reconciliation.

SELECT invoice_id,
       distribution_line_number,
       set_of_books_id,
       dist_code_combination_id,
       amount,
       posted_amount,
       period_name,
       posted_flag
FROM   ap_invoice_dists_all_mrc_v
WHERE  invoice_id = :invoice_id
AND    set_of_books_id = :sobid;

Because the ETRM metadata notes the view is not implemented as a permanent object in some environments, availability depends on whether Multi-Reporting Currency is enabled and the corresponding Payables MRC objects are deployed.