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
