My Oracle Support Banner

When Updating Payment Document Sequence Range, The First Check Number Created Is One Higher Than Expected (Doc ID 1322194.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.


On application version 12.1.3 the requirement is to create a new set of payment documents. 

To do this, the existing payment document sequence need to be updated.

For example :
- First Available Document Number : 533701
- Last Available Document Number : 533750
- Last Issued Document Number : 533700

When saving these changes,  below error is showing :

Last Issued Document Number must be greater than or equal to the First Available Document Number and lesser than or equal to the Last Available Document Number

Because of the error,  Last Issued Document Number has been changed to 533701  . The error message is avoided, but when a payment is issued, the first cheque number generated skips 533701 and is generated as 533702.

Expected behavior : For the new payment document set, expected the first cheque number (533701) to be available.


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

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