Oracle Error ORA-36763: (XSAGGCNTMOVE01) Aggregation variable workspace object cannot have itself as an AGGCOUNT.

Oracle Error Message

ORA-36763: (XSAGGCNTMOVE01) Aggregation variable workspace object cannot have itself as an AGGCOUNT.

Reason for the Error

An attempt was made to turn a variable into its own AGGCOUNT.

Solution

Select a different AGGCOUNT variable.