Oracle Solution for Error ora-36767

ORA-36767: (XSAGGCNTMOVE05) workspace object

cannot be used as an AGGCOUNT while there are permissions applied to it.

What triggered the Error:

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

What should we do to fix it:

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