Oracle Error Message
ORA-36378: (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.
Reason for the Error
While running AGGREGATE in threaded mode, you attempted to specify a WEIGHT variable in another analytic workspace.
Solution
Use a weight variable from the same analytic workspace as the aggmap and rollup variable.