How to store Oracle application output file in different location on the server

Date: 21-Aug-2017

Use case:

Oracle concurrent program will store output files in $APPLCSF/out location by default. This is done by standard vanilla implementation.


But there can be a scenario where you may want to store output file on different location.


For example in case of xml publisher reports you may want to store output (could be excel / PDF/ etc) on different custom folder.

How do you achieve this?

You could write some post processor after completion of the report/program.
Update FND_CONCURRENT_REQUESTS table outfile_name column with wherever location you want to store the file.


update fnd_concurrent_requests set outFile_name='/xx/out/INV/34505706.pdf' where request_id=34505706;


Important: Make sure that application server can access the location, because if you want to view output and if application server does not have access to the folder then you will not be able to view the output.


Thanks for visiting my blog.