Search Results po_distributions_interface




Overview
Explore in AI Chat

Overview

PO.PO_DISTRIBUTIONS_INTERFACE is a Purchasing (PO) module interface table that serves as the staging area for purchase order distribution records awaiting validation and import into the production distribution tables. In Oracle EBS 12.1.1 and 12.2.2, this table is populated by external sources—including the Purchasing Documents Open Interface, Oracle Manufacturing, project accounting feeds, and third-party integrations—before the concurrent program processes the rows and inserts them into the base distribution structures.

From a dimensional modeling perspective, the metadata classifies this object heuristically as standalone within a Data Vault framework. This suggests modeling the table as an independent structure rather than decomposing it into hub, link, and satellite entities. The table exposes 162 columns in the documented 12.2.2 schema, reflecting the broad range of purchasing, encumbrance, tax, project, and government-contracting attributes carried on each distribution.

The table is owned by the PO schema and, under ETRM conventions, supports deterministic row identity via a single-column unique index on INTERFACE_DISTRIBUTION_ID. Each row represents one distribution line of an interfaced purchase order or release, keyed by a unique distribution identifier assigned at load time.

Key Information Stored

The table's identity and cross-reference columns are central to processing. INTERFACE_DISTRIBUTION_ID is the surrogate primary key and the sole documented unique index candidate, while INTERFACE_HEADER_ID and INTERFACE_LINE_ID link the row to its parent header and line staging records. PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, and PO_RELEASE_ID carry the production identifiers to be assigned or matched on import.

Quantitative and financial attributes include QUANTITY_ORDERED, QUANTITY_DELIVERED, QUANTITY_BILLED, QUANTITY_CANCELLED, AMOUNT_ORDERED, and AMOUNT_BILLED. Encumbrance processing is governed by ACCRUE_ON_RECEIPT_FLAG, ENCUMBERED_FLAG, ENCUMBERED_AMOUNT, PREVENT_ENCUMBRANCE_FLAG, and FAILED_FUNDS_LOOKUP_CODE.

Accounting and destination context is captured through CHARGE_ACCOUNT_ID (and its CHARGE_ACCOUNT_SEGMENT1–CHARGE_ACCOUNT_SEGMENT30 decomposition), ACCRUAL_ACCOUNT_ID, VARIANCE_ACCOUNT_ID, SET_OF_BOOKS_ID, DELIVER_TO_LOCATION_ID, DESTINATION_ORGANIZATION_ID, and DESTINATION_SUBINVENTORY. Project-related attributes (PROJECT_ID, TASK_ID), tax attributes (RECOVERABLE_TAX), and the audit columns LAST_UPDATE_DATE, CREATION_DATE, REQUEST_ID, and PROGRAM_ID complete the essential profile.

Common Use Cases and Queries

The most frequent use is monitoring interface load status. Distributions with populated validation error flags or missing production IDs indicate pending or rejected rows:

  • Detecting unprocessed rows: SELECT INTERFACE_DISTRIBUTION_ID, INTERFACE_LINE_ID, PROCESS_CODE FROM PO.PO_DISTRIBUTIONS_INTERFACE WHERE PROCESS_CODE IS NULL OR PROCESS_CODE = 'ERROR';
  • Reconciling quantities before import against the source order and billed amounts to validate interface fidelity.
  • Auditing encumbrance and funds-check failures using FAILED_FUNDS_LOOKUP_CODE and ENCUMBERED_FLAG in financial close reporting.
  • Joining staging rows back to their parent header and line staging tables via INTERFACE_HEADER_ID and INTERFACE_LINE_ID to report full document context.
  • Cleansing batches by GROUP_LINE_ID prior to rerunning the import concurrent program.

Related Objects

The table's foreign keys connect it to several upstream and downstream objects:

  • RA_INTERFACE_DISTRIBUTIONS_ALL — referenced through INTERFACE_DISTRIBUTION_ID, linking to Receivables interface distributions.
  • PO_RELEASES_ALL — referenced through PO_RELEASE_ID, identifying the release to which the distribution belongs.
  • IGF_AW_AWARD_ALL — referenced through AWARD_ID, supporting government award tracking.
  • The base PO_DISTRIBUTIONS_ALL table, which receives validated rows on successful import.
  • PO_HEADERS_INTERFACE and PO_LINES_INTERFACE staging tables, joined by INTERFACE_HEADER_ID and INTERFACE_LINE_ID.
  • The Purchasing Documents Open Interface concurrent program, which consumes this table as its primary input.