ORA-30480

Error: ORA-30480: DISTINCT option not allowed with GROUP BY CUBE or ROLLUP

Causa: Window functions are allowed only in the SELECT list of a query. A window function cannot be a group function.

Acción: Modify the query such that only one rollup/cube expression appears per sub-query.