Oracle Solution for Error ora-36155

Solution for Oracle Error ORA-36155

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.

What triggered the Error:

The user specified an illegal variable for use with FROM or FROMVAR on the AGGREGATE command line

What should we do to fix it:

Specify a legal variable instead