Module: PONSourcingSeverity: HIGH
Sourcing Auto-Award to Standard Purchase Order Creation Failure
Enterprise troubleshooting playbook from the OAG ADK 5.0 knowledge base. Designed for Oracle Apps DBAs, techno-functional consultants, and support teams.
Recognized Error Signatures & Log Keywords
auto-award failedcannot create PO from bidPON_BID_HEADERS
Root Cause Analysis
Winning supplier site lacks purchasing site flag in AP_SUPPLIER_SITES_ALL.
Diagnostic SQL Queries (Read-Only)
CHECK_BID_STATUSVerify winning bid status and supplier site eligibility
SELECT auction_header_id, bid_number, bid_status, vendor_id, vendor_site_id
FROM pon_bid_headers
WHERE auction_header_id = :auctionIdRemediation Mode: MANUAL_UI
Verification Query
SELECT 1 FROM po_headers_all WHERE segment1 = :poNumber AND authorization_status = 'APPROVED'Execute This Fix Safely with OAG AI Consultant
OAG AI Consultant runs directly on your Windows desktop behind your corporate firewall, connecting to your Oracle TNS tier with zero cloud data exposure.