Search Results po_mc_distributions




Overview
Explore in AI Chat

Overview

PO_MC_DISTRIBUTIONS is the Multiple Reporting Currencies (MRC) sub-table of PO_DISTRIBUTIONS_ALL, owned by the PO schema within the Purchasing module of Oracle E-Business Suite. In an MRC-enabled environment, transactional data is captured once in the functional (primary) set of books and then revalued into one or more reporting sets of books using a defined exchange rate and rate date. PO_MC_DISTRIBUTIONS stores that reporting-currency representation of purchase order distribution records, allowing purchasing commitments and encumbrance balances to be reported in the reporting currency of a secondary set of books without duplicating the underlying purchasing transaction.

The table is documented as VALID in both the 12.1.1 and 12.2.2 releases, with a documented physical schema of six columns in 12.2.2. Its structure is intentionally narrow: each row links a base distribution to a set of books and carries the converted monetary amounts and conversion rate. From a Data Vault modeling perspective, the FK analysis classifies this object heuristically as standalone; however, because it is a dependent, per-set-of-books child of PO_DISTRIBUTIONS_ALL, it is most naturally modeled as a satellite hanging off the distribution hub, keyed by the combination of distribution identifier and set of books identifier. This classification should be treated as a modeling suggestion rather than a prescriptive design.

Key Information Stored

The documented columns provide a compact picture of the reporting-currency conversion record:

  • PO_DISTRIBUTION_ID — Reference to the parent distribution row in PO_DISTRIBUTIONS_ALL. This is the principal join column back to the base purchasing transaction.
  • SET_OF_BOOKS_ID — Identifies the reporting set of books for which the converted distribution amounts apply.
  • RATE_DATE — The date used to determine the exchange rate applied to the distribution.
  • RATE — The exchange rate applied between the functional currency of the primary set of books and the reporting currency of the target set of books.
  • ENCUMBERED_AMOUNT — The reporting-currency equivalent of the encumbered (committed) portion of the distribution.
  • UNENCUMBERED_AMOUNT — The reporting-currency equivalent of the unencumbered portion of the distribution.

The surrogate primary key is PO_MC_DISTRIBUTIONS_PK, defined over the composite of SET_OF_BOOKS_ID and PO_DISTRIBUTION_ID. A unique index, PO_MC_DISTRIBUTIONS_U1, is documented over the same pair in the reverse order (PO_DISTRIBUTION_ID, SET_OF_BOOKS_ID). Because both uniqueness constraints cover the identical column combination, they represent the single business key of this table — one distribution may appear only once per reporting set of books — rather than two independent candidate keys.

Common Use Cases and Queries

The table is typically queried to reconcile purchasing encumbrances and distribution amounts in a reporting currency, or to audit the exchange rate applied to a particular distribution. A representative join pattern follows:

  • Reporting-currency distribution extract: join PO_MC_DISTRIBUTIONS to PO_DISTRIBUTIONS_ALL on PO_DISTRIBUTION_ID, filtering by SET_OF_BOOKS_ID to isolate a single reporting set of books.
  • Encumbrance reconciliation: compare ENCUMBERED_AMOUNT and UNENCUMBERED_AMOUNT against the base-currency columns on PO_DISTRIBUTIONS_ALL, applying RATE to validate the conversion.
  • Rate audit reporting: group by RATE_DATE and RATE to detect distributions converted on unexpected dates or at unexpected rates.
  • Multi-set-of-books comparison: pivot ENCUMBERED_AMOUNT across SET_OF_BOOKS_ID values for a single PO_DISTRIBUTION_ID to view a distribution in every reporting currency simultaneously.

Reports such as purchasing commitment and obligation summaries in a secondary set of books, and MRC balance investigations, are the principal consumers of these queries.

Related Objects

The following objects are the most significant dependencies and join targets for PO_MC_DISTRIBUTIONS:

  • PO_DISTRIBUTIONS_ALL — Parent table; joined on PO_DISTRIBUTION_ID, supplying the base-currency distribution and PO header/line context.
  • PO_HEADERS_ALL — Reached through the distribution to obtain supplier, document type, and currency information for reporting.
  • PO_LINES_ALL — Reached through the distribution for item, quantity, and line-level pricing detail.
  • GL_SETS_OF_BOOKS — Joined on SET_OF_BOOKS_ID to resolve the reporting set of books name, currency, and chart of accounts.
  • GL_DAILY_RATES — Correlated on RATE_DATE and currency pair to verify or recompute the documented RATE.
  • PO_MC_HEADERS_ALL / PO_MC_LINES_ALL — Sibling MRC tables providing the header- and line-level reporting-currency equivalents that reconcile to the distribution-level amounts.

Because the table has no documented child foreign keys, it functions as a terminal MRC satellite; it is written and maintained by the Purchasing MRC conversion programs rather than by direct user entry.