Oracle Error QSM-01123: self-join algorithm could not resolve multiple instances

Oracle Error Message

QSM-01123: self-join algorithm could not resolve multiple instances

Reason for the Error

The generalized self-join algorithm could not resolve the mutliple instances, likely due to mismatch in joins or measures

Solution

Consider using aliases in the query to match with the aliases in the materialized view