TO SCHEDULE A COMPLETE REFRESH EVERY DAY AT 2AM
================================================
Alter MATERIALIZED VIEW xxap_liability_balances_mv REFRESH COMPLETE START WITH SYSDATE NEXT trunc(sysdate+1) + interval '2' hour;
Alter MATERIALIZED VIEW XXAP_GL_BALANCES_MV REFRESH COMPLETE START WITH SYSDATE NEXT trunc(sysdate+1) + interval '2' hour;