Search Results create_release_header




Overview
Explore in AI Chat

Overview

APPS.PO_RELGEN_PKG is the release generation engine within the Oracle Purchasing module of Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to transform qualified requisition lines into purchase order releases against existing blanket purchase agreements (BPA), and to propagate the resulting commitments through encumbrance, destination, and supply-chain logic. The package implements the automatic sourcing and release creation path that underpins the AutoCreate and Release Generation workflows.

The body is identified by the header string porelgeb.pls 120.30.12020000.4 and carries OpenWorld-style compilation directives such as <Encumbrance FPJ>, <INVCONV R12>, and <GRANTS FPJ>, which reflect R12-era enhancements including encumbrance processing, invoice conversion, and grants support. Debug tracing is controlled through the profile option AFLOG_ENABLED and the PO_DEBUG package, while user-facing error text is sourced from FND messages such as PO_REQ_TYPE, PO_ZMVOR_LINE, PO_ZMVOR_SHIPMENT, and PO_BLANKET_PO.

Key Procedures and Functions

The documented API surface exposes eleven procedures and functions. CREATE_RELEASES is the top-level driver that orchestrates release generation from requisition data. CREATE_RELEASE_HEADER creates the PO_RELEASES header record that links a requisition to a blanket agreement. CREATE_RELEASE_SHIPMENT builds the shipment-level detail associated with that release. MAINTAIN_SUPPLY manages supply and demand records supporting sourcing decisions.

GET_ASL_ID resolves the Approved Supplier List entry applicable to the item and supplier. GET_BEST_PRICE evaluates pricing to identify the optimal blanket agreement. GET_RCV_CONTROLS retrieves receiving controls from RCV_PARAMETERS, and GET_INVOICE_MATCH_OPTION determines the matching policy applied to the resulting release. OE_DROP_SHIP supports drop-shipment processing through Order Management. WRAPUP performs post-processing and cleanup after generation. CREATE_DELIVERYRECORD produces the delivery detail required by downstream logistics.

Private helpers include preapproval_checks, which validates requisition lines before release creation, and CREATE_RELEASE_DISTRIBUTION and create_award_distribution, which build distribution records.

Tables Accessed

The package reads and writes purchasing and requisition tables including PO_HEADERS, PO_HEADERS_ALL, PO_LINES, PO_RELEASES, PO_REQUISITION_HEADERS, PO_REQUISITION_LINES, and PO_REQUISITION_LINES_ALL. Sourcing logic references PO_AUTOSOURCE_DOCUMENTS and PO_AUTOSOURCE_RULES. System configuration is drawn from PO_SYSTEM_PARAMETERS, FINANCIALS_SYSTEM_PARAMETERS (and FINANCIALS_SYSTEM_PARAMS_ALL), GL_PERIOD_STATUSES for accounting-period validation, and RCV_PARAMETERS for receiving controls. AP_TAX_CODES_ALL supplies tax code validation for invoice matching.

Usage Notes

PO_RELGEN_PKG is invoked primarily by the Purchasing AutoCreate and release-generation flows and by concurrent programs that mass-create blanket releases. No other package in the documented dependency set references it, so invocation typically originates from standard forms, concurrent managers, or custom PL/SQL that calls these public APIs directly. Debug output can be enabled via AFLOG_ENABLED, and callers should expect error messages populated with line, shipment, and distribution identifiers from FND message sources.