You can achieve this by using the e-text report and having the output in csv format.
We do have similar requirement but we did that by using the shell script wrapper and modified the extension.
Mastering Oracle PLSQL Practical Solutions
CONNOR MCDONALD, WITH CHAIM KATZ,
CHRISTOPHER BECK, JOEL R. KALLMAN, AND DAVID C. KNOX
You Know Project Cost and Revenue; Do You Know Your Project Margin?
Very nice query and thanks a lot for your hardwork.
Sub Templates in Oracle BI Publisher
Troubleshooting Oracle Applications Performance Issues
Pricing Data Bulk Loader API
11i to R12 Table Changes
11 Reasons Oracle® E-Business Suite Projects Fail (And How to Fix Them)