Search Results po_autocreate_params




Overview
Explore in AI Chat

Overview

The APPS.PO_AUTOCREATE_PREPROC_PVT package body is a private (PVT) PL/SQL implementation unit within the Oracle E-Business Suite Purchasing module. It supports the AutoCreate functionality, the mechanism by which approved requisition demand is converted into purchase orders, releases, or RFQs. Specifically, this package performs the preprocessing phase that precedes the core AutoCreate engine. It reads the user-supplied selection criteria captured on the AutoCreate form, resolves them against system-level purchasing defaults, and prepares the working environment — including the temporary header interface records — before the main PO_AUTOCREATE_PVT engine executes its document creation logic. In EBS 12.1.1 and 12.2.2 the package is deployed in the APPS schema and is a dependency of the AutoCreate run-time path rather than a public API.

Key Procedures and Functions

Two documented program units constitute the package interface:

  • GET_SYSTEM_DEFAULTS — Retrieves and resolves the purchasing system parameters that govern AutoCreate behavior, such as default ordering and sourcing options held on PO_SYSTEM_PARAMETERS_ALL. These values are applied when the user has not supplied explicit overrides in the AutoCreate parameters, ensuring the run honors the organization's configured defaults.
  • PROCESS — The primary driver of the preprocessing stage. It consumes the AutoCreate parameters, validates and normalizes them, seeds the header interface, and hands control to the AutoCreate engine. Depending on the operating mode, it may invoke the external requisition and receiving routines exposed through RCV_CORE_S and related private utilities.

Tables Accessed

  • PO_HEADERS_INTERFACE — The AutoCreate staging table. Preprocessing writes provisional header rows here so that subsequent validation and document creation stages can operate on a controlled, transactional working set before final insertion into the purchasing tables.
  • PO_SYSTEM_PARAMETERS_ALL — Read to obtain organization-level purchasing defaults, including AutoCreate-related options, when explicit user parameters are absent.
  • PO_AUTOCREATE_PARAMS — Consulted for the AutoCreate parameter structure that defines the selection scope (requisition lines, grouping, and document type) for the run.

The package additionally references the PO internal utilities PO_AUTOCREATE_PVT, PO_CORE_S, PO_MESSAGE_S, PO_DEBUG, and PO_MOAC_UTILS_PVT, which provide the core creation, messaging, debugging, and multi-organization access services used throughout the preprocessing flow.

Usage Notes

This package is invoked internally by the Purchasing AutoCreate flow. In the EBS forms environment it is called when the user launches the AutoCreate Documents window and initiates a run; the parameters entered on that form — the direct analogue of the search term po_autocreate_params — are the inputs the package processes. In concurrent processing it is reached through the AutoCreate concurrent program path, where PO_AUTOCREATE_PVT orchestrates the broader job. Because the package is classified as PVT, it is not a supported public interface; customizations should call the documented public AutoCreate APIs rather than invoking PO_AUTOCREATE_PREPROC_PVT directly. Debug tracing can be enabled through the included PO_DEBUG dependency when diagnosing failed or partially seeded AutoCreate runs in either release.