ORA-02291

Error Text, Cause and Action from Message File/s for ORA-02291

Support Notes for ORA-02291

If you have a FOREIGN KEY constraint on a table you cannot INSERT or UPDATE rows such that they would not have a matching PARENT in the MASTER table.

Troubleshooting:

- Check if the PARENT row exists.

- Check the PARENT columns are indexed.

- Check the ORDER of the constraint.

  Eg: alter table d1 add constraint dd1 foreign key ( b,a ) references     e1( b,a );

  If there is a primary key on E1(A,B) this statement will process

  correctly but at insert time can raise errors. Ensure the ORDER

  of the columns matches the order of the PRIMARY KEY index.

- Disable the constraint - perform the action and then enable the constraint. 

  Does the enable work ?

LOG ERROR WEBLOGIC:

ORA-02291: integrity constraint (SIGFE_RI.FK_RIEE_RIRP) violated - parent key not found

Error Code: 2291

Call: INSERT INTO RIEE_ESTADOS_EXPORTACION (RIEE_ID, RIRP_ID, RITE_ID) VALUES (?, ?, ?)

bind => [727890, 38, 2]

RIEE_ESTADOS_EXPORTACION: