This content has been marked as final. Show 10 replies
Oracle Applications currently support this. Remove any spool command, as the application correctly calls a spool to the output directory with the adequate name (o999999.out). You may need to tweak other settings as this is also issued before running the script. The pagesize and linesize are inherited from concurrent program style definition.
SET TERM OFF
SET PAUSE OFF
SET HEADING OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET ECHO OFF
WHENEVER SQLERROR EXIT FAILURE
Thanks for the reply. However, what if you want to save the output to a particular location on the filesystem AND with a particular name? Also, how do you determine the name of the temporary file (e.g. o999999.out) and where it's saved?
In such case, to an specific location, when You specify a new spool command it replaces the prior, so no output will be shown after the second spool is issed, as the view output will look for the o99999999.out file.
The temporary file usually goes to $APPLCSF/out, and for the name, the number is obtained from the request id.
File goes to $APPLCSF/$APPLOUT/o<request_id>.out
I am basically trying to run a sql plus based concurrent program with three parameters and output as csv.
so its just a simple select with concatenated commas after every field and for the column headers to show i put a prompt
followed by the column names before the select statement.
when i run the conc. program in the output all i see is the column headers and the parameter name with no
parameters against them instead for one parameter it said "EXEC FND_CONC_STAT.COLLECT;" and
for the last one it said "EXIT".
can anybody tell me what i am doing wrong.
Edited by: user6343947 on Oct 31, 2008 2:57 PM
I have got exactly same requirement as yours now. I need to see the spool file from the concurrent manager output. Did you got solution for your problem.
If you got solution for this issue can you share with me how you did that?
Thank you very much
Use the "fnd_file" API.
Eg: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Your Output');
The file wil be created with teh request_id.out name in $APPL folder.
Once the file is created you can FTP this file to any location with any name.
To FTP the file create a printer/print driver and assign this printer to this concurrent program name.
The file will not be printed but FTP'd to specified location.
Hope this helps.
How did you define a printer of type ftp, to ftp the file.
Specify the driver method as command.
Enter your command string as an argument.
Create a printer type which uses this driver and an appropriate style.
Make sure you have a virtual printer which uses this type so that you can "print" to it to transfer your file.