For SQR, what controls output destination
Hello,
I am running Financials 9.0 through Bundle 45 with PeopleTools 8.52.17.
I am writing an SQR that creates a PDF file and a CSV file. When I run the SQR I use Web/PDF for the Report Type/Format. In the SQR, I use the "print" statements to create the PDF, which does go to the report repository (can see it in View Log/Trace of process monitor) as expected. For the CSV file, I open a file and use the "write" statements, but I can not see the csv file.
Also, in general, sometimes when I run the SQR, I see the output on the server path: dbname/appserv/prcs/dbname/log_output/SQR_progname_PI#, but sometimes it does not create that folder. Do you know what controls whether a folder is created for the SQR run in the server path or not?