I have created a persistent custom field (Dealer No) in business opportunity header which restrict users to input only Customer No from customer master:
Then I create a migration job to update that field:
I got the following error when trying to migrate the data:
Can anybody help to let me know where goes wrong?
Hi
Since this is a known Oracle error, ORA-02291: integrity constraint (XXX) violated - parent key not found which usually occurs when you have a parent-child relationship established between two tables through a foreign key and you try to insert a value into the child table, but the corresponding value does not exist in the parent table (foreign key value has no matching primary key value). To rectify the issue, you need to insert the value into the parent table first and then you can insert the corresponding value into the child table or remove the foreign key / add a matching primary key..
For more details please refer:
(1) https://www.techonthenet.com/oracle/errors/ora02291.php
(2) http://www.dba-oracle.com/t_ora_02291_integrity_constraint_string_string_violated_parent_key_not_found.htm
Hope this information will help !
Best Regards,
Yasas
Hi @Yasas_AK,
Sorry, can you advise what I need to do specifically? Those values that I was trying to insert into the child table (i.e. Business Opportunity table) already exist in the parent table (Customer Master).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.