Oracle Solution for Error ora-25966

Solution for Oracle Error ORA-25966

ORA-25966: join index cannot be based on an index organized table

What triggered the Error:

attempt to create a join index was made, which failed because one of the tables was an index organized table.

What should we do to fix it:

sure no underlying tables are index organized.