如果客户采用的是Oracle数据库，为了提升性能，K/3 Cloud 对很多常用视图，创建的是物化视图。
这在性能上非常有优势。
但是，这样处理的一个弊端，就是经常出现物化视图没有即时更新，未覆盖完整的原始数据，导致应用问题。
此时，可以在PL/SQL查询工具的Command Window下执行如下SQL语句，刷新物化视图：
create materialized view log on T_BD_BANK with rowid;
create materialized view log on T_BD_BANK_L with rowid;
create materialized view log on T_BD_CUSTOMER with rowid;
create materialized view log on T_BD_CUSTOMER_L with rowid;
create materialized view log on T_BD_DEPARTMENT with rowid;
create materialized view log on T_BD_DEPARTMENT_L with rowid;
create materialized view log on T_BD_SUPPLIER with rowid;
create materialized view log on T_BD_SUPPLIER_L with rowid;
create materialized view log on T_FIN_OTHERS with rowid;
create materialized view log on T_FIN_OTHERS_L with rowid;
create materialized view log on T_HR_EMPINFO with rowid;
create materialized view log on T_HR_EMPINFO_L with rowid;
create materialized view log on T_ORG_ORGANIZATIONS with rowid;
create materialized view log on T_ORG_ORGANIZATIONS_L with rowid;
exec dbms_mview.refresh('V_FIN_CONTACTTYPE','c');
exec dbms_mview.refresh('V_ITEMCLASS_OWNER','c');
exec dbms_mview.refresh('V_ITEMCLASS_KEEPER','c');
exec dbms_mview.refresh('V_FIN_CONTACTTYPE_L','c');
exec dbms_mview.refresh('V_ITEMCLASS_KEEPER_L','c');
exec dbms_mview.refresh('V_ITEMCLASS_OWNER_L','c');
exec dbms_mview.purge_mview_from_log();
特别说明：现场执行exec开头的语句即可
推荐阅读