Oracle Error QSM-01030: materialized view, string, has PL/SQL functions in ENFORCED integrity mode

Oracle Error Message

QSM-01030: materialized view, string, has PL/SQL functions in ENFORCED integrity mode

Reason for the Error

A materialized view with PL/SQL functions in its definition cannot be used for query rewrite when query rewrite integrity is set to ENFORCED.

Solution

Consider running the query in STALE TOLERATED mode.