This discussion is archived
5 Replies Latest reply: Sep 4, 2009 3:32 AM by user590824 RSS

Automatic E-mail Notification

440155 Newbie
Currently Being Moderated
Dear All friends

im new on collaboration sutie.

is there any way to make oracle suite send reports automatically to sepcific email address, E-mail contains repoert for example in PDF format, for example at 12 PM every day.

Mohammad
  • 1. Re: Automatic E-mail Notification
    420838 Newbie
    Currently Being Moderated
    Dear, have u find the way to forward the reports on email. plz let me to know if u have applied the procedure of reports to be sent through email automatically.

    Best Regards,
    Kashif
  • 2. Re: Automatic E-mail Notification
    432524 Oracle ACE
    Currently Being Moderated
    Hi folks!
    The OCS comes with an API for the Email Server. Using the API you can create an email and send it to the recipients.

    You can also try to send the email from the OS (eg. Unix) by using a normal commandline mail client (sendmail) with the report. You can schedule this from cron.

    Hope this helps.

    cu
    Andreas
  • 3. Re: Automatic E-mail Notification
    479960 Newbie
    Currently Being Moderated
    Hello,

    I am trying to find information on sending report output attached to an e-mail. I found an old posting about 9iAS being available with an e-mail server. The posting said, "You can find the email server from 9iAS supplemental CD Disk2, available to download from technet.oracle.com, the same page where you download 9iAS 1.0.2.2" We are currently running 10gASr2. I have the report server installed correctly, but I want to add the functionality of attaching a report to to an e-mail (destype=MAIL)

    I am trying the following:

    http://host.com:7778/reports/rwservlet?userid=user/pass@db+report=test.rdf
    destype=MAILfrom=sender@mail.domain.com+server=rep_midtier
    desname=receiver@mail.domain.comdesformat=pdf

    But I get "Error : REP-50159." All Oracle will tell me via Metalink is that I need to have an SMPT mail server that doesn't do any authentication. They will tell me nothing more, and believe me, I have been trying to get an answer out of them.

    Our current e-mail server uses IMAP authentication, so it won't work.

    Thanks for your help,
    Tony
  • 4. Re: Automatic E-mail Notification
    479960 Newbie
    Currently Being Moderated
    FYI, I found the answer. Just set the mailServer, in <ORACLE_HOME>/reports/conf/ my_report_server.conf file, to the local loopback controller and the report server will take it from there. (I.E. <pluginParam name="mailServer">127.0.0.1</pluginParam> )

    To test it, try

    http://host.domain.com:7778/reports/rwservlet?report=test.rdf&from=sender_address@email_domain.com&desformat=pdf&destype=mail&desname=receiver_address@email_domain.com

    Make sure you are using valid e-mail addresses.

    Hope this helps.

    Regards,
    Tony
  • 5. Re: Automatic E-mail Notification
    user590824 Newbie
    Currently Being Moderated
    Hi, My client is using oracle 11i and looking to send Order acknowledgement Reports automatically through e-mail to the customer. Any advice?