Oracle Solution for Error ora-14657

ORA-14657: cannot cascade row migration to reference-partitioned child table

What triggered the Error:

Update of a parent key may require migration of rows in reference-partitioned child tables, however this is not supported because the parent key was not suitably indexed.

What should we do to fix it:

Replace the existing index on the parent key with a unique index that does not contain any columns in addition to the parent key.