ORA-02292: Integrity Constraint

ORA-02292: Integrity Constraint



Sometimes user need to change foreign key attribute value in ADF table’s master detail relationship. If you try to change master table’s foreign key value, you’ll  get the following integrity constraint error message.

ORA-02292: integrity constraint (JAGRANDB.SYS_C00162401) violated – child record found


Download Sample Code


To resolve this issue, if user want to change a foreign key attribute in master table, then child table attribute’s value should also change consequently.

ADF has predefined features for this requirement.

  1. Go to Master Detail Association.
  2. In Behavior tab under relationship, check composition association.
  3. Then check “Cascade update key attributes”.





Output: –  This will result the following. When we change the department id in master table, then on child table department id automatically gets changed.





About Manish Pandey

Manish is a Project Leader at Jagran Prakashan Ltd, focused on Jdeveloper Fusion Web Application(specifically Oracle ADF). He shares his knowledge through the OTN Jdev/ADF Forum. He has written more than 50 article about Oracle ADF and Jdeveloper.

Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.