EAP: Voucher Maintenance Component Throws SQL Error When Trying To Save
Last updated on MARCH 18, 2016
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
When trying to change the Budget Date through Voucher Maintenance upon saving below error is generated.
PSAPPSRV.26106 (35) [2015-10-06T16:17:39.103 a1671242@LR90G25DH.ad.adelaide.edu.au (CHROME 45.0.2454.93; WIN7) ICPanel](3) File: /vob/peopletools/src/psppr/ramupd.cppSQL error. Stmt #: 1083 Error Position: 31 Return: 1779 - ORA-01779: cannot modify a column which maps to a non key-preserved table
1. Go to the Voucher Maintenance page:
2. Open a Multi Line Voucher.
3. Go to the Invoice Lines tab and select ‘Invoice line’ = 1.
4. Try to change the Budget Date (last column) to yesterday and click ‘Save’.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms