Oracle Solution for Error ora-14186

Solution for Oracle Error ORA-14186

ORA-14186: number of sub-partitions of LOCAL index must equal that of the underlying table

What triggered the Error:

User attempted to create a LOCAL partitioned index with a number of sub-partitions which is different from that of the underlying table.

What should we do to fix it:

Correct the CREATE INDEX statement to specify a correct number of sub-partitions