Oracle Error PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP

Oracle Error Message

PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP

Reason for the Error

User attempted to use the GROUPING function without GROUP BY CUBE or GROUP BY ROLLUP

Solution

Avoid using the GROUPING function without GROUP BY CUBE or ROLLUP