Oracle Solution for Error ora-32346

ORA-32346: ON COMMIT materialized view refresh caused changes to the master table/materialized view

What triggered the Error:

ON COMMIT refresh of a read-only materialized view changed the master table/materialized view. A trigger on the refreshed materialized view may be the cause.

What should we do to fix it:

Do not create triggers on materialized view which update the master table/materialized view.