Non Key-Preserved Table Error (ORA-01779)

You may get the following Oracle error when building a component with multiple scroll levels:

ORA-01779 cannot modify a column which maps to a non key-preserved table

What this is telling you is that PeopleSoft is trying to automatically write (insert/update) into a table that it should not be able to. More than likely, this will be a view.

One of the most common causes of this error is if you are using a grid, and behind the scenes your grid uses a view which is populated through PeopleCode. PeopleSoft will try to generate insert/update statements based on the current context in such cases unless you select the No Auto Update option in the grid properties.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License