Issue with Bursting Query in Oracle Report: "There is no data to process" Error

Sree29

I have created a report in Oracle that outputs data correctly when run on its own. However, when I attach a bursting query and run it through an ESS job, I receive the error: "There is no data to process", even though there is data available.

Here is the bursting query I am using:

SELECT '1' AS KEY,
'Department Delete Report' AS TEMPLATE,
'TEXT' AS OUTPUT_FORMAT,
'en' AS LOCALE,
'FTP' AS DEL_CHANNEL,
'PSA_DEV2_V2' AS PARAMETER1,
NULL AS PARAMETER2,
NULL AS PARAMETER3,
'/in' AS PARAMETER4,
'Department_Delete_' || TO_CHAR(SYSDATE, 'YYYYMMDD') || '_' || TO_CHAR(SYSDATE, 'HHMMSS') || '.csv' AS PARAMETER5,
'TRUE' AS PARAMETER6 -- secure FTP or not
FROM DUAL;

I have verified that the report runs fine without the bursting and produces data. The bursting query seems correct, and I'm using the following setup for the FTP output file. I have enabled bursting option as well.

Despite these efforts, the ESS job always returns the "There is no data to process" error. Any insights or suggestions on what might be going wrong?

Thanks in advance for your help!

Pattabhi Chereddy

I think you have to pass the data sets SQL code as a table instead of "DUAL" in your bursting code.