Oracle Solution for Error ora-40115

Solution for Oracle Error ORA-40115

ORA-40115: weights table schema is incorrect

What triggered the Error:

The weights table did not have the required schema.

What should we do to fix it:

Provide a weights table with schema: (target_value, weight), where the type of the first column corresponds to the type of the target column (CHAR, VARCHAR2 or NUMBER) and the type of the second column is NUMBER.