Oracle Error ORA-36767: (XSAGGCNTMOVE05) workspace object cannot be used as an AGGCOUNT while there are permissions applied to it.

Oracle Error Message

ORA-36767: (XSAGGCNTMOVE05) workspace object cannot be used as an AGGCOUNT while there are permissions applied to it.

Reason for the Error

The specified AGGCOUNT variable had its own permissions distinct from those on the aggregation variable.

Solution

Select a different AGGCOUNT variable, or remove the permissions. In some cases this may require an UPDATE before the command can succeed.