PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

For SQR, what controls output destination

edited Nov 10, 2014 10:41AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered ✓

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? 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center