Oracle Error Message
ORA-36170: (XSMXAGGR12) The data type of the WEIGHT workspace object must be numeric or BOOLEAN, not string.
Reason for the Error
The user specified a WEIGHT variable or formula which wasn’t numeric or boolean
Solution
Specify a numerical or boolean weight instead