Consolidated Invoice Review Page Showing Error: ¨Consolidated Invoices Must Be Released In A Sequential Order For A Consolidated Bill Group¨ (Doc ID 3066882.1)

Last updated on MARCH 11, 2025

Applies to:

Symptoms

When trying to release the credit consolidated Invoice on the Consolidated Invoice Review Page (PAConInvReviewPG) the following error is displayed:

Steps to reproduce:
-----------------------
The issue can be reproduced at will with the following steps:
1. Login into Oracle using a projects responsibily
2. Navigate to Project Forms Superuser > Billing > Consolidated Bill Group and create a new bill group
3. Navigate Projects and create a Billable project and assign Consolidated Bill Group to this project.
4. Create another project and assign the same consolidated Bill Group to this project too.
5. Navigate to Billing > Agreements. Create agreement and fund for both projects
6. Navigate to Project Web Superuser> Projects: Delivery> Search Projects
  a. Search for (Project 1)
  b. Click on Project Number
  c. Click on Financial Tab and then create budget for (Project 1)
  d. Repeat above mentioned step a to c for (Project 2)

8. Navigate to Billing > Events > all. Create a billable event for project.
9. Navigate to View> Requests> Submit a New Request. Run Program PRC: Generate Draft Invoices for a Range of Projects. Make sure that you choose Consolidated Bill Group
10. Navigate to Billing> Consolidated Invoice Review. Search for Consolidated Bill Group in search page.
11. Approve and Release Consolidated Invoice
12. Navigate to View> Requests > Submit a New Request. Run PRC: Submit Interface Streamline Processes to send draft invoice to AR.
13. Navigate to Billing> Consolidated Invoice Review. Search for Consolidated Bill Group in search page. Make sure that the Invoice status is Accepted in Receivable.
14. Navigate to Billing > Events > all. Create a billable event for second project created
15. Navigate to View> Requests> Submit a New Request. Run conc. Program PRC: Generate Draft Invoices for a Range of Projects. Make sure that you choose Consolidated Bill Group
16. Navigate to Billing> Consolidated Invoice Review. Search for Consolidated Bill Group in search page. There should be a consolidated invoice with unapproved status.
17. This is not correct. Both (Project 1) AND (Project 2) should in a single consolidated bill group instead of two different ones. So, cancelled (Project 1) consolidated invoice which submitted a concurrent request.
18. Navigate to Billing> Consolidated Invoice Review. Search for Consolidated Bill Group in search page. There should be a consolidated invoice for credit with Approved Invoice Status.
19. Navigate to View> Requests> Submit a New Request. Run conc. Program PRC: Delete Unreleased Draft Invoices for a Range of Projects. Make sure that you have consolidated bill group value for parameter.
20. Navigate to Billing> Consolidated Invoice Review. Search for Consolidated Bill Group in search page. Unapproved Consolidated Invoice should be disappeared now.
21. Now Release the Credit Consolidated Invoice number 3 and you will get error message: "Consolidated invoices must be released in a sequential order for a consolidated bill group"

Changes

Added modification on query to look for the last existent invoice number.

Cause

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