My Oracle Support Banner

EBI9.2: Express Billing Finalize Invoice - Data Being Updated Does Not Exist (Doc ID 2654400.1)

Last updated on APRIL 01, 2020

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to finalize express invoices in Billing, the following error occurs.

ERROR
-----------------------
Data being updated does not exist. (18,4)
When trying to save your changes, the system could not find the existing data in the database.
This problem can happen if another user deleted the information while you were making changes, Make a note of what you were doing, then cancel the page and retry.
If the problem persists this may be the result of an application programming error and should be reported to technical support staff.
Possible application error that could cause this including deleting the data with SqlExec while the record is in the component buffers.


REPLICATION STEPS
-----------------------
There are two things important to do this replication:

a. The user must have never run a process before

b. The user does not run any other processes for 7 days between finalizing invoices

 

1. Sign in as a user that has never run a process before : SELECT * from PS_PRCSRUNCNTL WHERE OPRID = 'EXA1'

2. Navigate to PeopleTools > Process Scheduler > System Process Request and create a new Run Control ID

3. Click the Run Button

4. Select the Simple AE test program (AEMINITEST) and click the ok button

5. Verify a row for the run control has been create in the PRCSRUNCNTL table

6. Navigate to Billing > Maintain Bills > Express Billing and search for the following:

7. Select the Invoice 0000678586 and click the Invoice button

8. Receive the following message:

" Invoicing initiating successfully. No further changes to this bill will be allowed during Bill Entry.

User has selected to invoice this bill. Once invoicing is initiated against a bill, you cannot perform any additional add or update action on the bill while still in Bill Entry."

9. Verify a row for the run control has been create in the PRCSRUNCNTL table

10.Wait a full 7 days (168 hours) and do not run any other processes as that user.

11. Verify no other run controls have been created for the user

12. Navigate to Billing > Maintain Bills > Express Billing and search for the following:

13. Select the Invoice OE-00091070 invoice and click the Invoice button

14. Receive the following error message:

"Data being updated does not exist (18.4)

When trying to save your changes, the system could not find the existing data in the database.

This problem can happen if another user deleted the information while you were making changes. Make a note of what you were doing, then cancel the page

and retry.If the problem persists this may be the result of an application programming error and should be reported to technical support staff.

Note: if clicking again on Invoice icon, bill will be successfully invoiced."

For the replication steps, please review Replication_File.

NOTE: In the  attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Changes

 

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
Changes
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.