How to fix the Oracle error ORA-36768: (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.?

In this post, you’ll learn more about the Oracle ErrorORA-36768: (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36768: (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.

Reason for the Error ORA-36768: (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.

An AGGCOUNT variable was specified with different base dimensions than the aggregation variable.

How to fix the Error ORA-36768: (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions. ?

You can fix this error in Oracle by following the below steps

Select an AGGCOUNT variable with exactly the same base dimensions as the aggregation variable.