Why is an AP invoice on hold?

AP Invoice On Hold — Investigation

TroubleshootingOracle Fusion · Financials · APHigh confidenceGenerated

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.

Likely causes

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

Check first

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

Relevant tables

AP_HOLDS_ALL

Curated

Invoice holds

Key columns

INVOICE_IDHOLD_LOOKUP_CODERELEASE_LOOKUP_CODEHOLD_DATE

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;

Fusion navigation

Navigator→Payables→Invoices→Manage Invoices