Oracle Error ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list

Oracle Error Message

ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list

Reason for the Error

An expression in the GROUP BY ROLLUP or CUBE list matches an expression in the ordinary GROUP BY expression list

Solution

Remove the expression from either ordinary GROUP BY expression list or ROLLUP or CUBE expression list