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.
