Yes indeed ... welcome.
Here is the documentation on DETERMINISTIC ...
You must specify this keyword if you intend to call the function in the expression of a function-based index or from the query of a materialized view that is marked REFRESH FAST or ENABLE QUERY REWRITE.




Reply With Quote