Results for “po_distribution_archive_xml”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PO_DISTRIBUTION_ARCHIVE_XML is a PL/SQL view owned by the APPS schema within the Oracle Purchasing (PO) module. It exposes the distribution-level accounting and receiving attributes of archived purchase order distributions in an XML-friendly, string-formatted shape. It is one of a family of "_ARCHIVE_XML" views that Oracle E-Business Suite provides to serialize archived transactional data (headers, lines, shipments, and distributions) for electronic communication, XML document generation, and outbound messaging through the PO Communication infrastructure. In release 12.1.1 and 12.2.2 the view remains VALID and is queried primarily by Oracle Purchasing's document publishing and archival retrieval programs rather than by end users directly.

The view does not store data itself; it is a projection over the archived distribution table and it converts numeric and date columns into character strings so that the payload can be embedded directly into an XML message without additional transformation logic.

Underlying Base Objects

The documented ETRM metadata lists the following objects referenced by the view definition:

• PO_DISTRIBUTIONS_ARCHIVE_ALL (SYNONYM) — the principal base table supplying all distribution rows, aliased as PD in the view text.
• PO_COMMUNICATION_PVT (PACKAGE) — provides the GETFORMATMASK function used to format numeric amount, rate, and encumbrance columns according to the operating unit's currency and precision settings.
• PO_COMMUNICATION_GT (SYNONYM) — supporting global temporary structure in the communication flow.
• GL_CODE_COMBINATIONS_KFV (VIEW) — key flexfield concatenated description view, providing the charge account display value.
• HR_LOOKUPS (VIEW) and HR_API (PACKAGE) — supply lookup meaning resolution.
• PER_ALL_PEOPLE_F (SYNONYM) — resolves deliver-to person details.

The essential relationship is one-to-one with PO_DISTRIBUTIONS_ARCHIVE_ALL: every qualifying archived distribution produces exactly one row with the same PO_DISTRIBUTION_ID.

Key Columns

The view exposes the full distribution identity and accounting surface. Important columns include:

• PO_DISTRIBUTION_ID, PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, PO_RELEASE_ID — the document hierarchy keys.
• CODE_COMBINATION_ID and the gl_code_combinations_kfv charge account — the accounting flexfield reference that drives general ledger posting.
• SET_OF_BOOKS_ID, BUDGET_ACCOUNT_ID, ACCRUAL_ACCOUNT_ID, VARIANCE_ACCOUNT_ID — accounting context references.
• QUANTITY_ORDERED, QUANTITY_DELIVERED, QUANTITY_BILLED, QUANTITY_CANCELLED — the receiving and matching quantities.
• AMOUNT_BILLED, ENCUMBERED_AMOUNT, UNENCUMBERED_AMOUNT, RATE — formatted as character strings via PO_COMMUNICATION_PVT.GETFORMATMASK.
• ACCRUED_FLAG, ENCUMBERED_FLAG, FAILED_FUNDS_LOOKUP_CODE, GL_ENCUMBERED_DATE, GL_ENCUMBERED_PERIOD_NAME, GL_CANCELLED_DATE — funds control status.
• DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID, DESTINATION_SUBINVENTORY, DESTINATION_CONTEXT — destination detail for inventory and expense routing.
• WIP_ENTITY_ID, WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM, BOM_RESOURCE_ID — work-in-process and bill-of-material references.
• ATTRIBUTE1 through ATTRIBUTE15, DISTRIBUTION_NUM, REVISION_NUM — descriptive flexfield and sequencing columns.
• CREATION_DATE and LAST_UPDATE_DATE — rendered as 'DD-MON-YYYY HH24:MI:SS' strings.

Common Use Cases and Queries

Because the view returns character-formatted values, the most frequent requirement is reconstruction of the charge account for an archived distribution. The following query retrieves the distribution and its charge account for a given purchase order:

SELECT PD.PO_DISTRIBUTION_ID, PD.PO_HEADER_ID, PD.PO_LINE_ID, PD.QUANTITY_ORDERED, PD.AMOUNT_BILLED, PD.ENCUMBERED_AMOUNT, C.CONCATENATED_SEGMENTS CHARGE_ACCOUNT FROM APPS.PO_DISTRIBUTION_ARCHIVE_XML PD, APPS.GL_CODE_COMBINATIONS_KFV C WHERE PD.CODE_COMBINATION_ID = C.CODE_COMBINATION_ID AND PD.PO_HEADER_ID = :P_HEADER_ID ORDER BY PD.DISTRIBUTION_NUM;

Other practical scenarios include auditing funds status for archived documents (filtering on ENCUMBERED_FLAG or FAILED_FUNDS_LOOKUP_CODE), reconciling billed versus delivered quantities across an archived release, and extracting accounting distributions for interface into external reporting or data warehouse layers.

Because all amounts are returned as strings, any arithmetic comparison should apply TO_NUMBER explicitly, and date filters should convert the character dates back using TO_DATE with the 'DD-MON-YYYY HH24:MI:SS' mask. The view is read-only; updates must be directed to PO_DISTRIBUTIONS_ARCHIVE_ALL.