Search Results doc_num_unique

Overview

PO_VAL_HEADERS is an Oracle EBS validation package in the APPS schema responsible for enforcing business rules on Purchase Order header data before records are committed to the database. It operates as a subordinate validation engine within the purchasing module, invoked by the higher-level PO_VALIDATIONS package to perform row-level and column-level integrity checks against both the PO_HEADERS_ALL table and its interface/GTL staging counterpart PO_HEADERS_GT. The package encapsulates header-specific validations covering pricing tolerances, agreement/contract dates, supplier status, currency rates, document numbering, and mandatory key references. Because validation logic is centralized here rather than duplicated in forms or concurrent programs, PO_VAL_HEADERS ensures consistent enforcement regardless of entry channel. It is registered as an OTHER-classified API package in ETRM for 12.2.2 and remains VALID in 12.1.1 environments.

Key Procedures and Functions

The package exposes 45 documented procedures and functions. The ETRM metadata names the following, grouped here by purpose:

• Price and amount validations: PRICE_UPDATE_TOL_GE_ZERO, AMOUNT_LIMIT_GE_ZERO, AMT_LIMIT_GE_AMT_AGREED, AMOUNT_AGREED_GE_ZERO, AMOUNT_AGREED_NOT_NULL, RATE_GT_ZERO. These enforce non-negative tolerances and amounts, ensure the amount limit is not less than the agreed amount, and require a positive currency exchange rate.
• Date and agreement validations: EFFECTIVE_LE_EXPIRATION, EFFECTIVE_FROM_LE_ORDER_DATE, EFFECTIVE_TO_GE_ORDER_DATE, CONTRACT_START_LE_ORDER_DATE, CONTRACT_END_GE_ORDER_DATE, CHECK_AGREEMENT_DATES. These confirm effective and contract date ranges bracket the order date and that expiration follows the effective date.
• Supplier and party validations: WARN_SUPPLIER_ON_HOLD, AGENT_ID_NOT_NULL, SHIP_TO_LOC_NOT_NULL, VENDOR_ID_NOT_NULL, FAX_EMAIL_ADDRESS_VALID. These verify mandatory buyer, vendor, and ship-to references and validate fax/email formatting, with a soft warning for suppliers on hold.
• Document controls: DOC_NUM_CHARS_VALID, DOC_NUM_UNIQUE, RATE_COMBINATION_VALID. These validate document number character rules, enforce uniqueness, and check currency/rate combinations.

Tables Accessed

Documented references (via APPS synonyms) include:

• PO_HEADERS_ALL and PO_HEADERS_GT: primary subject records and the GTL staging table used during validation of in-flight header data.
• PO_LINES_ALL, PO_LINES_GT, PO_LINE_LOCATIONS_ALL: line and scheduling context for header-level checks, particularly amount summaries.
• FINANCIALS_SYSTEM_PARAMS_ALL, PO_SYSTEM_PARAMETERS_ALL: system setup supplying default currency, precision, and tolerance behavior.
• PO_DOCUMENT_TYPES_ALL_TL, PO_DOC_STYLE_HEADERS, PO_PRINT_FORM_FORMATS: document type and print configuration for document number and style validation.
• HR_ALL_ORGANIZATION_UNITS_TL, ORG_FREIGHT: organization and freight references for ship-to and buyer validation.
• PO_HISTORY_POS_ALL, PO_ONLINE_REPORT_TEXT_GT, PO_SESSION_GT: history and reporting/session context.

Usage Notes

PO_VAL_HEADERS is not intended for direct invocation by end users. It is called indirectly through APPS.PO_VALIDATIONS, its sole documented referrer, which itself is referenced by purchasing forms, the PO Approval workflow, and header import/interface concurrent programs. Custom PL/SQL that must validate purchase order headers should call PO_VALIDATIONS rather than PO_VAL_HEADERS directly, since the parent package orchestrates header, line, and line-location checks in sequence and consolidates results into PO_VALIDATION_RESULTS_TYPE using the PO_TBL_DATE, PO_TBL_NUMBER, PO_TBL_VARCHAR2000, and PO_TBL_VARCHAR30 collection types. Because behavior is governed by system parameters and financials setup, validations such as amount tolerances and supplier-hold warnings vary by operating unit configuration. In 12.1.1 and 12.2.2 the object is identical in classification, and any modification should be avoided in favor of wrapping or extending PO_VALIDATIONS, as EBS treats this package as proprietary internal validation logic.