Oracle Error Message
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.
Reason for the Error
The user specified an illegal variable for use with FROM or FROMVAR on the AGGREGATE command line
Solution
Specify a legal variable instead