Oracle Error QSM-02081: mv log does not have all necessary columns

Oracle Error Message

QSM-02081: mv log does not have all necessary columns

Reason for the Error

The capability in question is not supported when the relevant materialized view log omits columns referenced in the select list of the materialized view.

Solution

Re-create the materialized view log and include all columns referenced in the select list.