Oracle Solution for Error ora-14196

Solution for Oracle Error ORA-14196

ORA-14196: Specified index cannot be used to enforce the constraint.

What triggered the Error:

The index specified to enforce the constraint is unsuitable for the purpose.

What should we do to fix it:

Specify a suitable index or allow one to be built automatically.