Message Oracle ORA-36155 - (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.

ERROR(XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.
CAUSEThe user specified an illegal variable for use with FROM or FROMVAR on the AGGREGATE command line
ACTIONSpecify a legal variable instead