Location where BI Publisher Report Output (PDF, EXCEL, HTML, RTF, etc.) stored in server

Many a times we come across requirement wherein we want to email/FTP report output generated from BI Publisher report. Well, you can get report output using below query :

SELECT outputfile_name
  FROM fnd_concurrent_requests
 WHERE request_id = p_request_id        -- (Request ID of your report program);

However, this query will give report output in .out format.
Suppose BI Publisher report is in RTF, EXCEL, HTML or PDF format and we want to email/FTP this report output, where can we get this from server?

This is stored in server and to get the location you can use below query :

SELECT file_type, file_name
  FROM fnd_conc_req_outputs
 WHERE concurrent_request_id = p_request_id -- (Request ID of your report program);

Hope this helps !!!