Search Results po_pdoi_preproc_pvt




Overview
Explore in AI Chat

Overview

APPS.PO_PDOI_PREPROC_PVT is a private (PVT) PL/SQL package within the Oracle Purchasing module of Oracle E-Business Suite. The designation "PDOI" refers to the Purchasing Document Open Interface, the inbound integration framework that loads externally sourced requisition, quotation, and purchase order data into the EBS purchasing schema. The "PREPROC" portion of the name identifies the package as a preprocessing component that executes ahead of the principal processing engine, PO_PDOI_PVT.

The package operates as an internal implementation layer and is not exposed as a public API. Its business role is to prepare and normalize the raw interface rows that arrive from external systems before they reach the main PDOI validation and import logic. This pre-processing stage resolves or transforms incoming data so downstream processing can map it into the production purchasing tables. Because it is classified as a private package, it is intended solely for consumption by other purchasing components rather than by customer extensions.

Key Procedures and Functions

The documented package interface contains a single procedure named PROCESS. This procedure serves as the entry point for the pre-processing phase of the purchasing document open interface. It performs the preparatory work — interpreting attribute and distribution rows against the header, line, and line location records supplied in the interface tables — before the same data is handed to PO_PDOI_PVT for full validation and insertion.

No public functions are documented for this package. Only the PROCESS procedure is referenced in the ETRM metadata, and it is invoked as part of the orchestrated PDOI import sequence rather than directly by end users.

Tables Accessed

The package reads from and writes to the standard PDOI interface tables and touches several production tables for reference data and error reporting:

These accesses reflect the package's responsibility for aligning inbound records with existing purchasing structures and recording issues encountered during preparation.

Usage Notes

PO_PDOI_PREPROC_PVT is invoked internally as part of the Purchasing Document Open Interface flow, typically through the concurrent program processes that load external purchasing data. It is not intended for direct invocation by custom code. The ETRM dependency report shows that it is referenced by the public package PO_PDOI_PVT, confirming that the public PDOI engine calls PO_PDOI_PREPROC_PVT before completing the import of a document.

Because the package is marked PVT and exposes only the PROCESS procedure, Oracle does not guarantee its signature across releases. Sites that require custom pre-processing of PDOI data should rely on the documented public PDOI interfaces or supported extension points rather than calling this package directly. This guidance applies equally to EBS 12.1.1 and 12.2.2, where the object remains valid and unchanged in its classification.