Skip to main content
Question

Excel Migration Job - integrity constraint error

  • August 27, 2025
  • 1 reply
  • 48 views

Forum|alt.badge.img+3

I’m getting this error when trying to migrate data to a Custom TAB.

 

ORA-02291: integrity constraint (IFSAPP.C_PART_INTERCHANGE1_CRK) violated - parent key not found

 

Method List Attribute

 

Source mapping

Note: I tried to retrieve the objkey from the parent container and set it using the source mapping, but I'm still getting the same error.

Any idea how to resolve this? 

1 reply

Forum|alt.badge.img+3
  • Author
  • Do Gooder (Partner)
  • December 1, 2025

This was resolved.

This error occurs when attributes have entity references. You can check this on the Entity Configuration page, and if there are any entity references linked to a field that you are going to migrate through a migration job, you must fetch the field value as shown below.

Ex: The source mapping for part_no shown below has an entity reference to part_catalog. In such scenarios, you need to fetch the objkey by passing the values in the format shown below. This resolved the parent key violation issue I mentioned earlier.