Search Results ap_mc_invoice_dists_u1

Overview

AP.AP_MC_INVOICE_DISTS is a Multiple Reporting Currencies (MRC) table in Oracle Payables that stores reporting currency information for each invoice distribution. In Oracle EBS 12.1.1 and 12.2.2, when one or more Reporting Sets of Books are defined alongside the primary set of books, this table holds the parallel reporting-currency representation of distribution-level accounting data, allowing an invoice to be reported in multiple currencies and ledgers without duplicating the transaction itself.

The table an optional one-to-many relationship with AP_INVOICE_DISTRIBUTIONS_ALL. For each invoice distribution in the primary table, several rows may exist in AP_MC_INVOICE_DISTS sharing the same INVOICE_ID and DISTRIBUTION_LINE_NUMBER but differing by SET_OF_BOOKS_ID. The row count for a given invoice line therefore corresponds to the number of Reporting Sets of Books defined. The relationship to AP_MC_INVOICES is mandatory and one-to-many.

From a Data Vault modeling perspective, the metadata's heuristic classification places this object as a standalone structure. In practice it behaves as a satellite attached to the distribution hub via INVOICE_DISTRIBUTION_ID, materialized per reporting set of books. The primary key AP_MC_INVOICE_DISTS_PK is defined on (INVOICE_ID, DISTRIBUTION_LINE_NUMBER, SET_OF_BOOKS_ID), with the unique index AP_MC_INVOICE_DISTS_U2 on (INVOICE_DISTRIBUTION_ID, SET_OF_BOOKS_ID) acting as the primary business-key candidate.

Key Information Stored

The table carries 22 documented columns. The most significant are:

• INVOICE_DISTRIBUTION_ID — surrogate identifier linking to the originating distribution; the anchoring component of unique index U2.
• INVOICE_ID, DISTRIBUTION_LINE_NUMBER, and SET_OF_BOOKS_ID — the composite primary key identifying the reporting-currency distribution per reporting ledger.
• DIST_CODE_COMBINATION_ID — accounting flexfield identifier for the expense account on the distribution line; carries index AP_MC_INVOICE_DISTS_N2.
• AMOUNT and BASE_AMOUNT — distribution amount in entered currency and its functional-currency equivalent, the latter used for foreign-currency invoices.
• EXCHANGE_RATE, EXCHANGE_DATE, EXCHANGE_RATE_TYPE, and RECEIPT_CONVERSION_RATE — the currency conversion attributes applied when producing the reporting-currency amounts.
• BASE_INVOICE_PRICE_VARIANCE, EXCHANGE_RATE_VARIANCE, and RATE_VAR_CODE_COMBINATION_ID — variance amounts and the account used for rate and price variance postings.
• LINE_TYPE_LOOKUP_CODE and QUANTITY_INVOICED — distribution classification and quantity basis.
• AMOUNT_TO_POST, BASE_AMOUNT_TO_POST, POSTED_AMOUNT, POSTED_BASE_AMOUNT, UPGRADE_POSTED_AMT, and UPGRADE_BASE_POSTED_AMT — the accounting-posting lifecycle amounts, distinguishing amounts pending posting from those already posted, including upgrade-related balances.

The surrogate identifier is INVOICE_DISTRIBUTION_ID, while the business-key candidates are the two unique indexes U1 and U2 enumerated above.

Common Use Cases and Queries

Typical use cases include reconciling reporting-currency amounts against the primary distribution, validating exchange rate application, and reporting payables activity by reporting ledger.

Retrieve all reporting-currency rows for a given invoice distribution:

• SELECT invoice_distribution_id, set_of_books_id, amount, base_amount, posted_amount FROM ap_mc_invoice_dists WHERE invoice_id = :invoice_id AND distribution_line_number = :line_num;

Compare entered versus base amounts across reporting sets of books, and identify unposted balances:

• SELECT set_of_books_id, SUM(amount) entered, SUM(base_amount) base FROM ap_mc_invoice_dists WHERE invoice_id = :invoice_id GROUP BY set_of_books_id;
• SELECT * FROM ap_mc_invoice_dists WHERE amount_to_post <> 0;

Join to the accounting flexfield to translate code combination identifiers, and join to AP_MC_INVOICES for invoice-level context. Because AP_MC_INVOICE_DISTS is populated only when Reporting Sets of Books exist, queries should guard against absent rows in a single-set-of-books environment.

Related Objects

• AP_INVOICE_DISTRIBUTIONS_ALL — joined on INVOICE_DISTRIBUTION_ID (and INVOICE_ID / DISTRIBUTION_LINE_NUMBER); the optional parent of the reporting-currency rows.
• AP_MC_INVOICES — mandatory one-to-many parent; joined on INVOICE_ID and SET_OF_BOOKS_ID.
• AP_MC_INVOICE_LINES — header-adjacent MRC table providing the invoice-line reporting-currency detail.
• GL_CODE_COMBINATIONS — joined via DIST_CODE_COMBINATION_ID and RATE_VAR_CODE_COMBINATION_ID to resolve account segments.
• FND_CURRENCIES / GL_DAILY_CONVERSION_TYPES — referenced through EXCHANGE_RATE_TYPE and related conversion attributes.
• AP_INVOICE_DISTRIBUTIONS_ALL via AP_MC_INVOICE_DISTS_U2 — the primary join path for distribution-level reconciliation reporting.