Answer Library

What tables contain AP invoices?

AP_INVOICES_ALL is the invoice header; lines, distributions, holds, payment schedule and settlement live in related child tables.

Give me SQL to find AP invoices by supplier.

Returns invoice header data for a given supplier (vendor).

Trace a sales order from header to fulfillment.

Traces a sales order from header through line to fulfillment status.

Why is an AP invoice on hold?

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.

What is the difference between AP_INVOICES_ALL and AP_INVOICE_LINES_ALL?

AP_INVOICES_ALL is the invoice header — one row per invoice. AP_INVOICE_LINES_ALL is the line-level detail — one row per item/expense line on that invoice — joined back by INVOICE_ID.

What tables contain AR invoices?

RA_CUSTOMER_TRX_ALL is the transaction header (invoice, credit memo, debit memo); lines, GL distribution, and settlement live in related tables.

How do I join an AR invoice to Subledger Accounting?

Connects an AR transaction (RA_CUSTOMER_TRX_ALL) through the accounting event tables (XLA_EVENTS) to the Subledger Accounting entry (XLA_AE_HEADERS, XLA_AE_LINES).

Why did Create Accounting fail?

Create Accounting fails when Subledger Accounting can't derive a valid GL journal from the transaction — usually a closed period, an invalid account, or an incomplete accounting rule mapping.