-- script for creating materialized view:

CREATE MATERIALIZED VIEW report_view1
ENABLE QUERY REWRITE
AS
select distinct trim(wrk.bd_alcd) as ALCD,
       wrk.bd_typecd as TypeCD,
       wrk.bd_forcd as FORCD,
       wrk.bd_curcd as CURCD,
       wrk.bd_councd as COUNCD,
       wrk.bd_sectcd as SECCD,
       wrk.bd_matcd as MATCD,
       wrk.bd_c_u_cd as C_U_CD,
       wrk.bd_s_u_cd as S_U_CD,
       0 as Org_FCBal,
       0 as ORG_Bal,
       case
            when wrk.bd_type='O' then wrk.bd_fc_bal
            else 0
       end as Main_FCBal,
       case
            when wrk.bd_type='O' then (wrk.bd_fc_bal * nvl(exchg.cer_exchangerate, 1))
            else 0
       end as main_Bal,
       wrk.bd_rs_int,
       wrk.bd_rs_bal,
       wrk.bd_fc_int,
       wrk.bd_fc_bal,
       ' ' as TrackChangs
from ibs_work_bankdata wrk
     inner join ibs_org_bankdata org
          ON org.bd_yrqtr = wrk.bd_yrqtr
          and org.bd_bkcode=wrk.bd_bkcode
          and org.bd_forcd = wrk.bd_forcd
     left join ibs_currencymaster curmst
          on curmst.cur_code = wrk.bd_curcd
     left join ibs_currencyexchangerate exchg
        	on exchg.cer_currencyid = curmst.cur_id

-- error:

ORA-01114: IO error writing block to file 202 (block # 3143441)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 3143568)
ORA-01114: IO error writing block to file 202 (block # 3143441)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 3143568)