ORA-56902
non-aggregate expressions inside the PIVOT clause
Cause
Non-aggregate expressions were used in the PIVOT clause of the SELECT statement, which is not allowed.
Action
Only aggregate functions are allowed in the PIVOT clause. Rewrite the SELECT statement and remove all non-aggregate functions and resubmit. Refer to Oracle Database documentation for the syntax of the PIVOT clause.