Oracle Error ORA-25965: fact table must be included in the from clause

Oracle Error Message

ORA-25965: fact table must be included in the from clause

Reason for the Error

An attempt to create a join index was made, which failed because the from clause does not contain the fact table.

Solution

Ensure that the from clause contains the fact table.