Oracle Message ORA-25950 - missing where clause in join index specification

ERRORmissing where clause in join index specification
CAUSEAn attempt to create a join index was made, which failed because no valid where clause was found.
ACTIONEnsure that a where clause with valid join conditions is specified in the create index statement.