Creating Materialized View Using AD_MV.CREATE_MV

begin
ad_mv.create_mv('XXABC_TEST_MV',
'create materialized view XXABC_TEST_MV'||
' build deferred refresh on demand as '||
' select /*AUTOREFRESH*/  * from per_jobs');
end;

Note:  While using this ad_mv.create_mv, you should not call plsql function, procedure calls in the MV sql statement.