Gapless Invoice Numbering Is Not Working Properly (Doc ID 1490040.1)

Last updated on JANUARY 03, 2023

Applies to:

Goal

It is desired to create Gapless invoice numbers, for example:

When two Suppliers Sites exists for the same Supplier:
  1-Gapless Invoice numbering is enabled and Invoice Summary level is Receipt
  2-Gapless Invoice numbering is not enabled
 

When creating a Purchase Order on a Supplier Site where Gapless numbering IS NOT enabled:
  -->Pay On receipt Autoinvoice creates an ERS invoice number with the correct sequence containing the Receipt Number
 
When creating a Purchase Order on a Supplier Site where Gapless numbering IS enabled:
  -->Pay On receipt Autoinvoice creates a ERS invoice number with the date as a number
  If creating a second Purchase Order and the second invoice with the same Supplier Site on the same day, the Payable Open Interface fails with the message:
      Duplicate Invoice Number for this supplier or party already exists

 ERROR
 -----------------------
  Duplicate Invoice Number for this supplier or party already exists

Solution

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