Issue:
::oracle.xdo.servlet.scheduler.ProcessingException: control file throws SAX parser exception::/u01/APPLTOP/instance/domains/fa.oracleoutsourcing.com/FADomain/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/to5gma/public/xdo_sched/718797/bip.bi_server1/t1/bipCVCPy0ctVm1213478483129404402.tmp::org.xml.sax.SAXException: Error happens when adding control property to map::localName = ROWControl xml does not have KEY tag defined. java.lang.Exception: Control xml does not have KEY tag defined.
Solution :
Make Sure there is a column name : KEY in the bursting control file query :
SELECT 1 KEY, ---bursting control file should have a column name KEY
'sample template name' template,
'en-US' locale,
'excel' output_format,
'EMAIL' del_channel,
'output file name' output_name,
'sample@email.com' parameter1,
'no-reply@test.com' parameter3,
'email subject' parameter4,
'sample email body' PARAMETER5,
'true' PARAMETER6
FROM DUAL