Search Results process_distributions




Overview
Explore in AI Chat

Overview

PO_AUTOCREATE_MAINPROC_PVT is an internal (private, "PVT" classification) PL/SQL package in the APPS schema that forms the core processing engine of the Oracle Purchasing AutoCreate feature. AutoCreate allows buyers to convert approved requisition lines into purchase order, blanket agreement, or contract documents automatically, rather than entering them manually. The MAINPROC ("main process") package is responsible for the central stage of that flow: taking the staged interface records that represent the buyer's selected requisition demand and building the header, line, line location, and distribution records that ultimately become the new purchasing documents.

The package sits between the selection/user-interface layer and the post-processing layer. Its private status indicates it is not a public API intended for direct customer invocation; it is designed to be called by other AutoCreate packages during the standard concurrent and form-driven workflows.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions:

  • PROCESS — The driving entry point that orchestrates the full main processing cycle for a run.
  • PROCESS_HEADERS — Creates and populates purchase order header information in the interface and destination tables from the staged requisition data.
  • PROCESS_LINES — Builds the purchase order line records corresponding to the requisition lines being autocreated.
  • PROCESS_LINE_LOCATIONS — Generates the shipment/line location records for each processed line, including schedule quantities and dates.
  • PROCESS_DISTRIBUTIONS — Creates the distribution records that carry accounting and charge information for each line.
  • GROUP_INTERFACE_RECORDS — Consolidates and organizes the staged interface rows so that related requisition demand is grouped appropriately before document creation.
  • HAS_ONE_TIME_LOCATION — A helper function that determines whether a one-time (non-reusable) location is involved in the transaction.
  • GET_SHIP_TO_LOC — A helper function that resolves and returns the appropriate ship-to location for the document being built.

The logical processing order is grouping, then headers, then lines, then line locations, then distributions, all coordinated by PROCESS.

Tables Accessed

Via APPS synonyms the package touches three broad groupings of tables. Interface and draft tables — PO_HEADERS_INTERFACE, PO_DISTRIBUTIONS_INTERFACE, PO_HEADERS_ALL, PO_LINES_ALL, PO_LINES_ALL_EXT_B, PO_DISTRIBUTIONS_ALL, PO_LINES_DRAFT_ALL, and PO_DISTRIBUTIONS_DRAFT_ALL — hold the incoming staging data and the draft or final purchasing records it produces. Master and reference data — MTL_SYSTEM_ITEMS, MTL_GRADES, MTL_UNITS_OF_MEASURE, HR_LOCATIONS_ALL, and HZ_LOCATIONS — supply item, grade, unit of measure, and location attributes used to validate and default values on the new documents. Setup and descriptive flexfield data — FINANCIALS_SYSTEM_PARAMS_ALL and FND_ATTACHED_DOCUMENTS — provide system parameters and attachment handling respectively.

Usage Notes

PO_AUTOCREATE_MAINPROC_PVT is not intended for standalone customer calls. It is referenced by four other packages — PO_AUTOCREATE_POSTPROC_PVT, PO_AUTOCREATE_PVT, PO_AUTO_LINE_LOC_PROCESS_PVT, and PO_AUTO_LINE_PROCESS_PVT — which invoke it as part of the end-to-end AutoCreate run. It typically executes in the context of the AutoCreate concurrent program and the AutoCreate form, after requisition lines have been selected and staged, and before post-processing finalizes and releases the documents. Because it is a private package, customizations should avoid depending on its signature, as Oracle may change private package interfaces between releases such as 12.1.1 and 12.2.2.