My Oracle Support Banner

R12: Understanding Oracle Payment Numbering (Doc ID 1390985.1)

Last updated on MAY 22, 2023

Applies to:

Oracle Payments - Version 12.0.0 and later
Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
Author: Mitesh Kumbhat


To assist customers in their understanding of how Oracle Payments generates and uses payment numbers in Oracle Payables (AP) and Oracle Payments (IBY).


This document is intended for functional and technical users of version R12 of the Oracle Payments (IBY) and Oracle Payables (AP) applications.

This article focuses entirely on "creditor" payments -- that is, payments made to suppliers, employees (for expenses), and to customer/suppliers for refunds requested by Receivables (AR).


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
  1. Business requirements
  2. Payment identification numbers in Oracle application
 2.1. Payment reference number
 2.2. Payment document number
  3. Data model representation of payment number at transaction level
 3.1  Table AP_CHECKS_ALL
  4. Example Data
  5. Payment number display in user interface
  6. Issues faced by users
  7. Best Practices
 Have more questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.