Oracle Error ORA-38496: Expression Filter index is not in a valid state

Oracle Error Message

ORA-38496: Expression Filter index is not in a valid state

Reason for the Error

An attempt was made to REBUILD an Expression Filter index that was not valid.

Solution

Use DEFAULT keyword in the parameters clause to rebuild the index from defaults or drop and recreate the index.