My Oracle Support Banner

R12: Invoice Reviews Form: AR Invoice Numbers Sequence Is Skipped (Doc ID 2570293.1)

Last updated on AUGUST 07, 2019

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On 12.1.3 with R12.PJ_PF.B.DELTA.7:

Receivables invoice number sequence is skipped.

Reproducible Steps
------------------

In the Invoice Reviews form:

Query an existing project.
Note: the last AR invoice number was 100.

1. Draft Invoice #11 had status 'Approved'. Click the "Released" button.
**** DO NOT save yet *****

2. Then Release the next draft invoice #12.

3. Now, click Save. AR invoice numbers are generated as:

PA Invoice# AR Invoce#
---------------------------------------------------------
11 102 -- Got skipped. It should be 101
12 103 -- This should be 102

NOTE:
=====
-The issue occurs only in the case when draft invoices got Released one after
another WITHOUT saving each record in between.

Cause

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
Symptoms
Cause
Solution
References


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