Oracle Error Message
QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode
Reason for the Error
A join present in the materialized view requires validated primary/foreign key constraints in ENFORCED query rewrite integrity mode.
Solution
Validate the constraint or change the integrity mode with ALTER SESSION SET QUERY_REWRITE_INTEGRITY = STALE_TOLERATED command.