How to create .txt files using bursting

Summary:

Requirement is to generate a .txt file with Job Posting description for Job Requisitions meeting certain criteria

Content (required):

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

Bursting query

SELECT Distinct REQUISITION_NUMBER AS KEY

,'JobPosting_eTxt_External' AS TEMPLATE