EMail through concurrent request....

<html><div style='background-color:'><DIV>
<P>Hi Friends,</P>
<P>We are using Oracle Applications version 11.5.4. I need your inputs on how to send emails to LOTUS NOTES through oracle applications. I dont want to use workflow notification activity to send email, instead i need to send email after the successfull completion of a concurrent request. One of the business scenerio is that we are checking the customer credit limit through an custom concurrent program. We want that if the credit limit is failed it should send email to the concerned person.</P>
<P>Please let me know what are the steps required to achive this. What modifications we have to d in the PL/SQL program?? How to configure OCA UNIX m/c with mail server?? Any help would be highly appreciated.</P>
<P>Regards!!</P>
<P>Vikram</P>
<P><br />
</P></DIV>
<DIV></DIV>

You can use the utl_smtp standard Oracle Db package to send mails. I have copied the pl/sql script below which you can modify and use as per your convinience. I think it uses the OS mail system to send mails, e.g., if your OS is unix it will use SENDMAIL to send mails, so, not only utl_smtp, but send mail should also be properly configured on your server.

You can replace " '' || crlf || ' This mail is used in testing SMTP calls'; " with your mail body contents and if you want to send mail to more then one recipients then you have to use the "utl_smtp.rcpt( conn, ReceiverAddress );" command with each mail-id.

Or else you can even try using the sendmail option of your unix server but for that you will need to do some shell scripting too, which I have never done.

One: At the end of the concurrent program script make a call to start a
simple workflow process to send the email. This method does seem to add
another layer but would work.

Two: Move all the logic into a workflow process which checks the customer
credit and sends the emails. Then simply initiate the workflow from the
concurrent program. Workflow gives you much more flexibility and control of
the email and the program logic.

Got Concurent requests you can send mails to
designated persons by giving the address of the person
in the email to information while submitting the
concurrent request.
Else if you want to derive the name of the person
dynamically depending upon some query then you can use
the following approach:
You can include a call to utl_smtp programs in the
place where you determine the credit limit has failed
or if you want to send the entire report then
create a unix script that will be called as a
concurrent program that can send the entire report
file as an output to any person of your choice.
You can submit the report and the concurrent as a
request set.
Inside the unix script yous can make use od the mail
utility or mailx.
Regards