R12 When Delete a Project Consolidate Invoice Only The Draft Invoices Related To One Project Are Deleted

(Doc ID 2339312.1)

Last updated on DECEMBER 14, 2017

Applies to:

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

Symptoms

When deleting project consolidated invoices the following behavior occurs:

ACTUAL BEHAVIOR
---------------
The consolidated invoice number is deleted but only the draft invoices related to the one project number are deleted


EXPECTED BEHAVIOR
-----------------------
The expectation is to have deleted all the draft invoices related to all projects which are linked to the related consolidated invoice number
The draft invoices related to the related project number should also be deleted since this project is linked to the same consolidated invoice and to the same Consolidated Bill Group

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Projects responsibility > Billing > Invoice Review > query the related Operating Unit and the related Consolidated Bill Group and check the Invoice mode: Consolidated Invoices then click on the Find button

2. Click on the related Consolidated Invoice Number and see that the Invoice Status is Unapproved > click on Open button

3. On the Invoice Summary > click on the first line having the related Project Number and Draft invoice

4. Click on Run Request button and select the option "Delete Invoices"

5. The concurrent  PRC: Generate Draft Invoices for a Range of Projects is automatically lunched for invoice deletion.

6. Check the invoice status

On the Projects responsibility > Billing > Invoice Review > query the related Operating Unit and the related Consolidated Bill Group and check the Invoice mode: Consolidated Invoices then click on the Find button
See that the related Consolidated Invoice Number is deleted.

7. On the Projects responsibility > Billing > Invoice Review > fill in the related project number and select the Invoice mode: Invoice Mode Draft Invoices > click on the Find button
   The message "FRM-40350: Query caused no records to be retrieved" is returned

8. On the Projects responsibility > Billing > Events> All > fill in the related project number > click on the Find button
on the related Event Number the Bill Amt value can be changed

9. On the Projects responsibility > Billing > Invoice Review > fill in the related project number and select the Invoice mode: Invoice Mode Draft Invoices > > click on the Find button
and see that the related Consolidated Invoice Number is displayed

10. On the Projects responsibility > Billing > Events> All > fill in the related project number > click on the Find button
on the related Event Number the Bill Amt value can't be changed.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms