If you get the error How to fix ORA-01502: index or partition of such index is in usable state in Oracle. It is possible that an index is broken from a table.
To fix this error, you can do the following:
rebuild the index with the following SQL command:
ALTER INDEX your_index_name