Oracle Message ORA-25957 - join index where clause cannot contain cycles

ERRORjoin index where clause cannot contain cycles
CAUSEAn attempt to create a join index was made, which failed because the where clause contains a cycle.
ACTIONEnsure that the where clause is in the form of a star or snowflake schema.