Oracle Fusion/Financials/AP

IBY_PAYMENTS_ALL

Oracle Payments — the actual payment created by a payment process request, before it becomes an AP check row.

Key Columns

PAYMENT_IDPAYMENT_PROFILE_IDPAYEE_PARTY_IDPAYMENT_AMOUNTPAYMENT_CURRENCY_CODEPAYMENT_STATUS_CODE

Child Tables

IBY_DOCS_PAYABLE_ALL

Documents payable — one row per invoice selected into a payment, carrying the paid amount and discount taken.

Common Joins

IBY_DOCS_PAYABLE_ALLvia PAYMENT_ID

The documents payable (invoices) paid by this payment.

AP_CHECKS_ALLvia PAYMENT_ID = EXTERNAL_BANK_ACCOUNT_ID?

The Payables payment record, linked by the payment reference.

Used In

APPayments

Notes

The AP_CHECKS_ALL link is by payment reference rather than a single FK — confirm the join column in your release.

How a Payables payment is built and accounted

A payment process request selects invoices as documents payable (IBY_DOCS_PAYABLE_ALL) and creates payments in Oracle Payments (IBY_PAYMENTS_ALL). Payables records the payment in AP_CHECKS_ALL, and every subsequent event (clearing, void) is a row in AP_PAYMENT_HISTORY_ALL that Create Accounting posts.