Search Results po_autocreate_preproc_pvt




Overview
Explore in AI Chat

Overview

PO_AUTOCREATE_PREPROC_PVT is a private PL/SQL package owned by the APPS schema within Oracle E-Business Suite. In the Oracle EBS 12.1.1 and 12.2.2 releases, this package forms part of the Purchasing module's internal infrastructure that supports the AutoCreate workflow — the mechanism by which approved requisitions are converted into standard purchase orders, blanket releases, or other purchasing documents. As indicated by the "PVT" suffix, the package is classified as a private API, meaning it is intended solely for internal consumption by Oracle's own Purchasing AutoCreate code rather than as a public, supported integration point.

The package operates as a preprocessing utility, performing preparatory validation and setup steps that must complete before the actual AutoCreate processing logic executes. It conditions the runtime environment and interface tables so that downstream routines can safely transform requisition demand into supply documents without encountering data integrity errors.

Key Procedures and Functions

The documented package exposes two executable units:

  • GET_SYSTEM_DEFAULTS — A procedure that retrieves the applicable purchasing system parameters and defaulting values required to drive the AutoCreate process. It establishes the baseline configuration context (for example, default organization and processing options) that governs how requisition lines are selected and interpreted during AutoCreate.
  • PROCESS — A procedure that executes the core preprocessing activity for the package. It orchestrates the preparatory steps against the purchasing interface structures so that subsequent AutoCreate routines operate on a consistent, validated set of data.

No parameter lists are documented in the reference metadata, and they are deliberately omitted here. The two routines are intended to be called in sequence by the parent AutoCreate logic rather than independently.

Tables Accessed

The package references the following tables through APPS synonyms:

  • PO_HEADERS_INTERFACE — The purchasing headers interface table, used as the working staging area into which purchase order header information is loaded and validated during AutoCreate. The package interacts with this structure to prepare and cleanse incoming header records.
  • PO_SYSTEM_PARAMETERS_ALL — The Purchasing system parameters table, read to obtain the system-level defaults and processing options that influence AutoCreate behavior. This supports the GET_SYSTEM_DEFAULTS routine.

The header-line interface tables (such as PO_LINES_INTERFACE) are not documented as direct references for this package, reinforcing its narrow preprocessing scope.

Usage Notes

PO_AUTOCREATE_PREPROC_PVT is invoked internally by the Purchasing AutoCreate framework. The dependency metadata indicates that it is referenced by other APPS packages, notably PO_AUTOCREATE_PVT, which is the primary AutoCreate driver. This confirms the preprocessing package is called from within the AutoCreate concurrent program flow rather than from a form directly.

Typical invocation occurs when a user submits the Purchasing "AutoCreate" concurrent request to convert approved requisitions into purchase orders. Because the package is classified as PVT and is not published as a public API, it should not be called directly from custom code. Customers extending AutoCreate functionality should rely on supported public APIs instead. Direct invocation risks failure because private package signatures may change across patch levels or releases.