My Oracle Support Banner

How To Setup Gapless Document Sequencing in Receivables (Doc ID 197212.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Receivables - Version 11.5.0 and later
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Form:FNDSNDSQ.FMB - Define Document Sequences
Form:FNDSNDCT.FMB - Define Document Categories
Form:FNDSNASQ.FMB - Assign Document Sequences
Form:ARXTWMAI.FMB - Transactions
Executable:RAXTRX - Autoinvoice Import Program
Executable:ARXREC - Recurring Invoice Program


Oracle Receivables (AR): AutoInvoice Information Center Note 197212.1

Oracle Receivables (AR): Transactions Workbench Information Center Note 197212.1



Please note that in Oracle Receivables GAPLESS document sequencing only applies to INVOICES. You can use document sequences to uniquely number Receipts, Bills Receivables, Adjustments, and other data objects, but they are not guaranteed to be gapless. The implementation steps detailed in this document only applies to Invoices.


This document covers setup specific to gapless document sequences. For a more general discussion on document sequences in Receivables, please review Note 1086565.1, How To Setup Document Sequences In Receivables.
In some countries, it is a legal requirement that transactions are numbered in a gapless sequence for audit purposes.

Gapless document sequences ensure that there are no gaps or missing numbers in your document sequence. By using this feature in tandem with the Copy Document Number to Transaction Number setting in your transaction source definition, you can generate gapless transaction numbers.

This document provides steps on how to setup Gapless document sequencing within Receivables.

Introducing the Oracle Receivables Document Sequence Analyzer DocID 2021711.1     

The EBS Oracle Receivables Document Sequence Analyzer is a self-service health-check script that reviews Receivables related data, analyzes current configurations and settings for the environment and provides solutions for known issues, feedback and recommendations on best practices.




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. Enable Sequential Numbering Profile Option
 2. Setup System Options
    a. Set Document Number Generation System Option to When Completed
    b. Disable Changes to Printed Transactions and Transaction Deletion
 3. Define a Transaction Type
 4. Define a Batch Source 
 5. Define a Document Sequence
 6. Define a Document Category
 7. Assign a Document Sequence to the Document Category
 8. Test your Setup
 9. Representation in AR Tables
 10. Other Gapless Sequence Configurations
 11. References
 12. Troubleshooting Document Sequences
 Still Have Questions?

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