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.
