Home » Applications » Oracle Fusion Apps & E-Business Suite » Report Output in Excel sheet
Report Output in Excel sheet [message #194164] Thu, 21 September 2006 01:32 Go to next message
Messages: 4
Registered: July 2006
Junior Member

i want take report output in Excel sheet can any one help me

Re: Report Output in Excel sheet [message #194165 is a reply to message #194164] Thu, 21 September 2006 01:36 Go to previous messageGo to next message
Messages: 180
Registered: July 2005
Senior Member

Please search in this forum. You should find some answers.
Re: Report Output in Excel sheet [message #194226 is a reply to message #194164] Thu, 21 September 2006 04:19 Go to previous messageGo to next message
Messages: 413
Registered: October 2005
Location: Surrey, England
Senior Member

As ngouadjeu said, there are plenty of postings on this subject already, at least one of which I have posted myself. If you can't find anything appropriate by searching for Excel, try CSV or log in to MetaLink and search for INSTALL and "VIEWER OPTIONS" which will display several articles.

You could also search the "Oracle Applications System Administrator's Guide" for "Viewer Options".

If you don't have a copy of the Oracle Applications System Administrator's Guide, it can be downloaded, with all of the other Applications Documentation from http://www.oracle.com/technology/documentation/applications.html

Cool HTH

Re: Report Output in Excel sheet [message #194740 is a reply to message #194226] Mon, 25 September 2006 01:09 Go to previous message
Messages: 34
Registered: November 2005
Location: India

if you want out put as csv file,You need to develop a Shell script, and you are required to run the report in shell script itselfe. create a concurent program with excutable method of tyoe is host,
and pass the parameters to report in shell script
by using 'mailx' function you can also mail the output to user.
you can use this script.

P_SOURCE=`echo $1| cut -d " " -f9|sed 's/"//g'`
P_GROUP=`echo $1| cut -d " " -f10|sed 's/"//g'`
P_ORG_ID=`echo $1| cut -d " " -f11|sed 's/"//g'`
P_TMAIL_ID=`echo $1| cut -d " " -f12|sed 's/"//g'`
echo "Entered Variables "
echo "Source : ${P_SOURCE} "
echo "Group : ${P_GROUP_ID} "
echo "Org ID : ${P_ORG_ID} "
echo "To Mail ID : ${P_TMAIL_ID} "
echo "File Name ${FILENAME} "
OUTPATH=`echo "$APPLCSF/log"`
echo "Output Path ${OUTPATH} "
echo "p_source='${P_SOURCE}'" >test.cmd
echo "p_group='${P_GROUP_ID}'" >>test.cmd
echo "p_org_id='${P_ORG_ID}'" >>test.cmd
echo "userid=${APPS_USR_PSWD}" >>test.cmd
echo "report=$FSG_TOP/reports/US/FSG_INV_Report_CSV.rdf" >>test.cmd
echo "batch=yes" >>test.cmd
echo "destype=file" >>test.cmd
echo "desname=$OUTPATH/${FILENAME}" >>test.cmd
echo "desformat=delimited" >>test.cmd
echo "delimiter='~'" >>test.cmd
echo "paramform=NO" >>test.cmd
# running the report
cd $FSG_TOP/reports/US
ar60run cmdfile=${OUTPATH}/test.cmd
STATUS=`echo $?`
if [ $STATUS -ne 0 ]
echo "Report generation has returned error "

SUBJECT=`echo "Invoice error report $FILENAME for Org $P_ORG_ID"`
(echo "Please see the file attached"; echo "This is an automated email.Please do not reply to this. "; uuencode $FILENAME $FILENAME ) | mailx -s "$SUBJECT" ${P_TMAIL_ID}

Previous Topic: Looking Job in Oracle 11i Apps ( mfg & Dist)
Next Topic: Doubt in Multi-Org while creating business group
Goto Forum:

Current Time: Sun Oct 23 02:59:21 CDT 2016

Total time taken to generate the page: 0.07739 seconds