Ronnie, you have to set in init.ora:

query_rewrite_enabled = true
query_rewrite_integrity = trusted

Thus you will enable the function based index functionallity.

Has the user who runs the query been granted query rewrite?