I have created the Rquest setin oracle apps.
In which
10 position i am executing report &
20 position i am callling script
#!/bin/ksh
# Get reguest id
REQ_ID=Request id of Previous report (10)
REQ_ID="`echo ${REQ_ID}`”
CONN_STRING=`cat $ORACLE_HOME/reports60/server/CGIcmd.dat |grep $TWO_TASK|grep html|awk ‘ { print $2 } ‘ |awk -F= ‘ { print $2 } ‘`
FILE=$APPLCSF/$APPLOUT/o$REQ_ID.out
EMAIL_ID=`sqlplus -s $CONN_STRING <<EOF1
WHENEVER SQLERROR EXIT FAILURE ROLLBACK
SET HEADING OFF
SET FEEDBACK OFF
SELECT decode(mail_alias,null,’swapnil_tamhane@yahoo.com’,mail_alias) || ‘,’
FROM mailtable
WHERE group_name = ‘MAIL GROUP’;
exit success;
EOF1`
EMAIL_ID="`echo $EMAIL_ID`”
mailx -s “Report file of Request id:$REQ_ID $FILE” $EMAIL_ID <$FILE

Problem : No i am struct up how to get the REQ_ID of Position 10 so that i can derive the name of the output file.

If you have any other solution then u can advice me.
Thanks in advance.

HI Kishore

If user run the report,report running successfully.but,output not send to her mail. Please any one help onthis issu.ites very urget

plase find the log file ERROR below

-------------------------------------------

APP-FND-00500: AFPPRN received a return code of failure from routine FDUPRN. An error occurred while AOL tried
to spawn the print process

Cause: AFPPRN received a return code of failure from the OSD routine FDUPRN. An error occurred while AOL tried to spawn the
print process.

Action: Review your concurrent request log file for more detailed information.
========================================================================

Regards,
Sreehari.

Hi Braj,

when i am using the below command from the $ prompt the file is sent as an attachment to my email.

$ uuencode filepath/filename test.txt | mail -s “Test email” <email address>

But when the same thing used in the script that is run from apps as a concurrent program.

the contents of the file is put into the body,but not has an attachment.

Can you please let me know how to handle this.

Thanks,
Npal