Why Is Before Remove Trigger Being Called When Adding New Record? (Doc ID 2731087.1)

Last updated on NOVEMBER 23, 2020

Applies to:

Goal

There are two triggers on the object with the same if statement condition, but different error messages thrown.
- a before Remove trigger
- a before Insert trigger.
When trying to remove a record from the collection, the error message which is displayed is the correct one, corresponding to the Before Remove trigger.
When trying to add a record to the collection, the error message which is displayed is not the expected one (the one in the Before Insert trigger), but the one corresponding to the Before Remove trigger.

Why is this happening?

// Before Remove trigger
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

if(1 == 1)  // this is generic condition
{
throw new oracle.jbo.ValidationException("Error message from Before Remove")
}
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

// Before Insert trigger
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
if(1 == 1)  // this is generic condition
{
throw new oracle.jbo.ValidationException("Error message from Before Insert")
}
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.