Oracle Error Message
QSM-01106: materialized view, string, is stale with respect to some partition(s) in the base table(s)
Reason for the Error
Query is requesting some data from the MV that are stale with respect to some partitions in the base tables due to some updates.
Solution
refresh the stale partitions and rerun the query