__IF_EXISTS__
SELECT 1
  FROM CI_UT_INSTL_DTL
WHERE SCRIPT_FILE_NAME = 'FW45001_POSTDATA_OUAF-34712.SQL'
   AND END_DTTM IS NOT NULL
/
__THEN__
__EXIT__
__ENDIF__

insert into  ci_rpt_option (rpt_opt_flg, version, rpt_option_val) select 'F1S2', 1,  rpt_option_val from ci_rpt_option where rpt_opt_flG = 'RPSV' and rpt_option_val is not null and rpt_option_val <> '@BI_PUBLISHER_ADMIN@' and not exists (select 1 from ci_rpt_option where rpt_opt_flG = 'F1S2')
/

insert into  ci_rpt_option (rpt_opt_flg, version, rpt_option_val) select 'F1S2', 1,  '@BI_PUBLISHER_ADMIN_INT@' from ci_rpt_option where rpt_opt_flG = 'RPSV' and rpt_option_val is not null and rpt_option_val = '@BI_PUBLISHER_ADMIN@' and not exists (select 1 from ci_rpt_option where rpt_opt_flG = 'F1S2')
/
