Cause: 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. See the solution below.
Error solution: Drop the join index or remove the constraint.
Database version: Oracle 11g Release 2 (11.2)