Why I can't use the hint FRESH_MV on a RTMV ??

Hi

I have a Real Time Materiliazed view which works very well and the data is always up-to-date with the information pushed from the MLogs when the refresh is not yet completed.

However, when I try to do the query over the MV directly using the hint FRESH_MV ( to get the real time data from the MV itself ), I got always an error because of this filter in the where condition of my select statement:

AND (:var24 IS NULL OR supplier.thirdPartyNumber IN (select regexp_substr(NVL(:var25 ,''),'[^,]+', 1, level) from dual connect by regexp_substr(NVL(:var26 ,''), '[^,]+', 1, level) is not NULL))