Why is an AP invoice on hold?

AP Invoice On Hold — Investigation

Oracle Fusion · Financials · AP

TroubleshootingHigh confidence

Invoices go on hold when validation finds a matching, tax, variance or funds issue. Holds are recorded on AP_HOLDS_ALL and must be released before the invoice can be accounted or paid.

Grounded in: Curated Oracle knowledge layer — AP

Check First

Query AP_HOLDS_ALL for the invoice to see the exact HOLD_LOOKUP_CODE.
Check whether the hold is at the invoice header or a specific line/distribution.

Likely Causes

Matching discrepancy — invoice price or quantity doesn't align with the PO/receipt within tolerance.
Tax calculation hold — tax setup incomplete for the supplier/item combination.
Funds check failure during budgetary control validation.
Duplicate invoice — the same supplier invoice number was entered twice.

Diagnostic SQL

SELECT
  hold_lookup_code,
  hold_date,
  release_lookup_code,
  release_date
FROM ap_holds_all
WHERE invoice_id = :invoice_id
ORDER BY hold_date DESC;

Key Tables

AP_HOLDS_ALL

Invoice holds

Fusion Navigation

Navigator → Payables → Invoices → Manage Invoices