Oracle Solution for Error ora-40120

Solution for Oracle Error ORA-40120

ORA-40120: invalid weight value in the weights table

What triggered the Error:

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

What should we do to fix it:

Ensure that weight values in the weights table are strictly positive.