ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list
What triggered the Error:
An expression in the GROUP BY ROLLUP or CUBE list matches an expression in the ordinary GROUP BY expression listWhat should we do to fix it:
Remove the expression from either ordinary GROUP BY expression list or ROLLUP or CUBE expression list