EAP: Voucher Maintenance Component Throws SQL Error When Trying To Save (Doc ID 2102974.1)

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.

Symptoms

Issue:
-------
When trying to change the Budget Date through Voucher Maintenance upon saving below error is generated.

Error/Messages:
-----------------
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

Steps:
-------
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’.

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