Oracle Error QSM-02192: commit SCN based MV log is not in consistent state

Oracle Error Message

QSM-02192: commit SCN based MV log is not in consistent state

Reason for the Error

The capability in question is not supported when the relevant materialized view log is not in consistent state due to the failure when populating the mapping table of SYS.SNAP_XCMT$.

Solution

Perform a complete refresh of the materialized view.