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: Delivery date, delivery number and delivery quantity
Next Topic: Is Activex control require to install?
Goto Forum:

Current Time: Wed Aug 23 07:04:38 CDT 2017

Total time taken to generate the page: 0.09464 seconds