Concurrent Request_XML format has data but RTF or EXCEL format has NO data

I ran a request with output option in RTF/EXCEL. The request completed successfully. If I click the Request Output, the RTF/EXCEL file open up, but there is NO data (ie. company name, dollar amount etc). However, if I click the Request Diagnostics and View XML, the XML format has ALL the data.

In above scenario, the request was triggered by Automic (partner company of Oracle). I know this may not be a common situation, but generally what could cause such issue?

If I manually run the same report in Oracle, both the default RTF output file and the XML file in Diagnostics have all the data.