The view DWH_TRD_SUM_TREND_BY_PER_MV remains in invalid state. The recompilation of the view also doesn't make the view valid. The execution of the query related to the view in database directly returns records without any issue.
Steps to Reproduce:
Expected Results:
The view DWH_TRD_SUM_TREND_BY_PER_MV should remain in valid state.
Actual Results:
The view DWH_TRD_SUM_TREND_BY_PER_MV goes to invalid state.
Version: 16.1.3.
DE78604
DE78604 is fixed in v16.2.1.