Oracle Error ORA-25961: join index prevents dml cascade constraint operation

Oracle Error Message

ORA-25961: join index prevents dml cascade constraint operation

Reason for the Error

An attempt to execute dml resulted in the need to perform dml on another table because of a cascade constraint. The join index only allows one of its underlying tables to me modified at a time.

Solution

Drop the join index or remove the constraint.