Oracle Message ORA-25963 - join index must be created on tables

ERRORjoin index must be created on tables
CAUSEAn attempt to create a join index was made, which failed because the from clause contains non table object.
ACTIONEnsure that the from clause only contains tables.