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
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.
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
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.