OracleOps AI
← All tables
Oracle Fusion/Financials/AP

AP_HOLDS_ALL

Holds placed on an invoice (matching, tax, variance, etc.) that block payment/accounting.

Key Columns

INVOICE_IDHOLD_LOOKUP_CODERELEASE_LOOKUP_CODEHOLD_DATE

Parent Table

AP_INVOICES_ALL

Invoice header — supplier, amount, invoice date, payment terms, currency.

Common Joins

AP_INVOICES_ALLvia INVOICE_ID

The invoice this hold is blocking.

Used In

AP

Related

AP invoice holds

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

AP invoice data model

AP_INVOICES_ALL (header) → AP_INVOICE_LINES_ALL (lines) → AP_INVOICE_DISTRIBUTIONS_ALL (accounting). Payment status lives on AP_PAYMENT_SCHEDULES_ALL and settlement on AP_INVOICE_PAYMENTS_ALL/AP_CHECKS_ALL.

Ask Oracle AI about AP_HOLDS_ALL