Oracle Solution for Error ora-01779

Solution for Oracle Error ORA-01779

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

What triggered the Error:

An attempt was made to insert or update columns of a join view which map to a non-key-preserved table.

What should we do to fix it:

Modify the underlying base tables directly.