EAP: Data being updated does not exist. (18,4) error when using SpeedChart to override Invalid Chartfields on Recycle Voucher (Doc ID 1473991.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

If using a SpeedChart to override the invalid chartfields on a Recycled Voucher, when saving the Voucher, an 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 errors that could cause this including deleting the data with SqlExec while the record is in the component buffers.

STEPS
1. Load staging table using Excel Voucher Upload Spreadsheet for a Voucher with an invalid PROJECT_ID field value.
2. Run Voucher Build process.
3. Review the Voucher created. Voucher is in Recycle status with following errors.

Project   ChartField error for value 12345678 fieldname Project, (prompt table PROJECT_ID_VW).    
Project   Invalid PC Business Unit, Project ID, and Activity ID combination.

4. Choose a SpeedChart value in the Invoice Line to override the invalid chartfields. SpeedChart contains chartfields such as Account, Department, Program, PC Business Unit, Project and Activity.
5. Save the Voucher.
6.  Above error is received.

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