ERROR DURING EXECUTION OF OWM TRIGGER DUE TO INTEGRITY CONSTRAINT VIOLATION (Doc ID 964843.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Workspace Manager - Version: 10.2.0.4.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

We have a parent-child relationship (Foreign Key)
Both tables are version enabled.

Inserting a record into the PARENT table generates error:

ERROR at line 1:
ORA-20006: integrity constraint (SCOTT.CHILD_FK) violated - parent key not
found
ORA-06512: at "SCOTT.OVM_INSERT_9", line 4
ORA-04088: error during execution of trigger 'SCOTT.OVM_INSERT_9'
ORA-06512: at "SCOTT.OVM_INSERT_10", line 3
ORA-04088: error during execution of trigger 'SCOTT.OVM_INSERT_10'


This should not be the case because we are inserting into the PARENT table
not the CHILD table.

There is an AFTER INSERT PER ROW trigger created on the PARENT table:

CREATE OR REPLACE TRIGGER I_CREATE_CHILD
AFTER INSERT ON PARENT
FOR EACH ROW
BEGIN
INSERT INTO child (child_id, parent_id) VALUES (:new.parent_id,
:new.Parent_id);
END;
/

According to the documentation this trigger seems to be allowed.
As it is an after insert, the row in the PARENT table should be there to
validate the insert that is going into the CHILD table.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms