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
krish12
Messages: 4
Registered: July 2006
Junior Member
Hi

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

Regards
Krish
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
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Hi,

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
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
Senior Member
Krish,

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

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

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} "
FILENAME="${P_ORG_ID}_INV_ERRREP_${P_GROUP_ID}_${VDATE}.csv"
echo "File Name ${FILENAME} "
OUTPATH=`echo "$APPLCSF/log"`
echo "Output Path ${OUTPATH} "
cd ${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 ]
then
echo "Report generation has returned error "
fi;

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}


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


Current Time: Fri Dec 09 06:13:41 CST 2016

Total time taken to generate the page: 0.11893 seconds