Module: APInvoice MatchingSeverity: CRITICAL
PO 3-Way Match Price Variance Exceeds Configured Tolerance Rule
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
price variance holdprice tolerance exceededinvoice line exceeds po unit pricePRICE_TOLERANCE
Root Cause Analysis
Invoice unit price {invPrice} exceeds PO price {poPrice} beyond allowed tolerance percentage.
Diagnostic SQL Queries (Read-Only)
CHECK_TOLERANCECompare invoice line unit price against PO line location unit price
SELECT il.unit_price AS inv_price, pl.unit_price AS po_price,
pl.unit_price * (1 + NVL(t.price_tolerance, 0)/100) AS max_allowed
FROM ap_invoice_lines_all il
JOIN po_lines_all pl ON il.po_line_id = pl.po_line_id
LEFT JOIN ap_tolerance_templates t ON t.tolerance_id = :toleranceId
WHERE il.invoice_id = :invoiceIdRemediation Mode: MANUAL_UI
Verification Query
SELECT count(*) FROM ap_holds_all WHERE invoice_id = :invoiceId AND hold_lookup_code = 'PRICE' AND release_lookup_code IS NULLExecute 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.