Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
How to create .txt files using bursting — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to create .txt files using bursting

Received Response
17
Views
4
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!