Oracle Error ORA-36766: (XSAGGCNTMOVE04) workspace object cannot be used as an AGGCOUNT because it has an AGGCOUNT.

Oracle Error Message

ORA-36766: (XSAGGCNTMOVE04) workspace object cannot be used as an AGGCOUNT because it has an AGGCOUNT.

Reason for the Error

The specified AGGCOUNT variable had its own AGGCOUNT

Solution

Select a different variable, or remove the AGGCOUNT using CHGDFN.