Oracle Error ORA-40120: invalid weight value in the weights table

Oracle Error Message

ORA-40120: invalid weight value in the weights table

Reason for the Error

Negative or zero weight values were found in the weights table.

Solution

Ensure that weight values in the weights table are positive.