How to create .txt files using bursting
Requirement is to generate a .txt file with Job Posting description for Job Requisitions meeting certain criteria
We are having issue in generating a .txt file when bursting is used. The text file gets generated when report runs online but we are getting below error when scheduled to use bursting.
oracle.xdo.servlet.data.DataException: Invalid format requested: xml
Tried adding Data Xml and Data CSV as format options. The report then sends the entire data set and not the report file.
I am using below template
SELECT Distinct REQUISITION_NUMBER AS KEY
,'JobPosting_eTxt_External' AS TEMPLATE