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

ERRORself-join algorithm could not resolve multiple instances
CAUSEThe generalized self-join algorithm could not resolve the mutliple instances, likely due to mismatch in joins or measures
ACTIONConsider using aliases in the query to match with the aliases in the materialized view