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”.

 

1

 

 

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

2

 

 

 

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 *

*