Oracle Error ORA-28117: integrity constraint violated – parent record not found

Oracle Error Message

ORA-28117: integrity constraint violated – parent record not found

Reason for the Error

try to update/insert a child record with new foreign key values, but the corresponding parent row is not visible because of fine-grained security in the parent.

Solution

make sure that the updated foreign key values must also visible in the parent