OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Report Output in Excel sheet

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report Output in Excel sheet [message #194164]

Thu, 21 September 2006 01:32

krish12
Messages: 4
Registered: July 2006

Junior Member

Hi

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

Regards
Krish

Report message to a moderator

Re: Report Output in Excel sheet [message #194165 is a reply to message #194164]

Thu, 21 September 2006 01:36

agostino_neto
Messages: 180
Registered: July 2005

Senior Member

Hi,

Please search in this forum. You should find some answers.

Report message to a moderator

Re: Report Output in Excel sheet [message #194226 is a reply to message #194164]

Thu, 21 September 2006 04:19

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

Report message to a moderator

Re: Report Output in Excel sheet [message #194740 is a reply to message #194226]

Mon, 25 September 2006 01:09

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 12:52:45 CDT 2024