Report based on MV: Deliberately make the report fail if MV is out of date? I have a query that is used in a BIRT report (in IBM's Maximo Asset Management platform).
I'm considering storing the query in a materialized view in order to improve performance and reduce the load on the system.
Question:
Is a way to deliberately make the report fail  if the MV is out-of-date?

In other words, we'd rather have no data in the report, than wrong data.

Edit:
I removed the excessive details from the question.
Why bother at all with a new column, when you can just check LAST_REFRESH_DATE in ALL_MVIEWS before executing the actual query.
ALL_MVIEWS
And there is basic/advanced query rewrite as well.