APEX

I have a report whose behavior I cannot explain. It is a based SQL Query based report. When I enable export to CSV, the resulting file contains a single cell with the word OMIT repeated over and over again.

The query is nothing special.

select t.name "Site Name",
t.prmt_id "Permit",
t.efctv_dt "Effective Date",
t.cd "Status",
sf.disturb_acres "Dist. Acres",
case 
 when t.loc_addr2 is null
 then t.loc_addr1
 else t.loc_addr1||' '||loc_addr2
end "Site Address",
cnty.name "Site County",
t.loc_city_name "Site City",
t.fac_id,t.sect_id,
cf.CNTCT_NAME "Contact Name",
c.name "Mail Company",
case when c.MAIL_ADDR2 is null
  then c.MAIL_ADDR1 
  else c.MAIL_ADDR1||' '|| c.MAIL_ADDR2
  end "Mail Address",
c.MAIL_CITY_NAME "Mail City",
c.MAIL_STATE_CD "Mail State",
case when c.MAIL_ZIP4_CD is null
 then c.MAIL_ZIP_CD
 else c.MAIL_ZIP_CD||'-'||c.MAIL_ZIP4_CD
end "Mail Zip"
from v_tim_old t, cnty, stmwtr_fac sf, cmpy_fac cf, cmpy c
where t.loc_cnty_cd=cnty.cd
and t.fac_type_cd='C'
and t.fac_id=sf.fac_id(+)
and t.sect_id=sf.fac_sect_id(+)
and t.fac_id=cf.fac_id(+)
and t.sect_id=cf.fac_sect_id(+)
and cf.cmpy_seqno=c.seqno
and c.seqno=(select min(cmpy_seqno) from cmpy_fac cf1 where t.fac_id=cf1.fac_id and t.sect_id=cf1.fac_sect_id)
and instr(t.name,'DOT') >1
and cf.RELTN_TYPE_CD='OP'

The output does not contain any column headings and cell A2 contains:

OMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMITOMIT

I verified and all of the columns are marked include in export. This is the only report that this happens to.

Apex: 3.1.0.00.32
Database: 10.1.0.3 and 10.2.0.3

I am a little baffled.

Tony