Error: "Unexpected Oracle error: ORA-02292: integrity constraint" (4282574)

Error: "Unexpected Oracle error: ORA-02292: integrity constraint (IBE_ADMIN.FK_FARE_SALE_FARE_SALE_ID) violated - child record found. (object name: "IBE_ADMIN"."COMPONENTS") [sp_opst (for o.sp3PRDUBET-o.sp1PRDUBET queue admin_queue)/11588] "

"Notice: ORA-02292: integrity constraint (IBE_ADMIN.FK_FARE_SALE_FARE_SALE_ID) violated - child record found. [sp_opst(osp)/11588]"

Child table has BEFORE DELETE trigger to delete from parent table first. On source, oracle allows the delete to succeed since it was in the same transaction, but on target, it fails because delete on parent comes first and then delete on child follows.

To resolve this issue change the trigger from BEFORE DELETE to AFTER DELETE on child table.