Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-28117

integrity constraint violated - parent record not found

Cause

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.


Action

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