OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Sending Emails from E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Sending Emails from E-Business Suite

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

Sending Emails from E-Business Suite [message #126478]

Tue, 05 July 2005 03:25

joemullins
Messages: 3
Registered: July 2005

Junior Member

Hi ,
we are in the process of implementing Oracle 11i...

Our consultants tell us that we can automate the sending of emails from PO system..

If we want ( for example ) to email a Sales Order Acknowledgement to a customer when created , it looks like we'll need a 3rd party app or some development..

Or if we want to email/fax Invoices...?

Has anyone any pointers/comments?

Thanks in advance

Joe

Report message to a moderator

Re: Sending Emails from E-Business Suite [message #126534 is a reply to message #126478]

Tue, 05 July 2005 07:50

adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway

Senior Member

Two ways of sending emails would be either to use Oracle Alerts or Oracle Workflow. Take a look in the user guides available on the documentation CD.

In Oracle Alerts you can define event or periodic alerts. The first happens when some change is performed in a table, where as the other is as its name suggests executed on a periodic basis. The alert can be to a limited degree be dynamically generated by substituting values for attributes.

If you go for Oracle Workflow, you would probably want to define business events for the events that should trigger an email if there are not seeded business events you can use. Then you would define workflows that are kicked off by these events and register their subscription to these business events.

In Oracle Workflow you have more freedom than in Oracle Alerts. If you use PL/SQL documents you can create very sophisticated dynamically generated emails.

--
Aleksander Dragnes

Report message to a moderator

Re: Sending Emails from E-Business Suite [message #126539 is a reply to message #126478]

Tue, 05 July 2005 08:22

vikrams
Messages: 23
Registered: November 2000
Location: Dubai

Junior Member

Hi,

Some more info.

You can use 1 to 1 Fulfillment Also.
This is a part of CRM foundation Product.
You can go through the User and implementation guides avaliable on metalink or oracle site.

Workflow requires much more complicated method.
It requires experienced and skillful persons.

I see that, 1 to 1 Fulfillment is better option

Just want to add the posibilities the functionality can be achieved. Cool

Thanks,
Vikram

Report message to a moderator

Re: Sending Emails from E-Business Suite [message #126547 is a reply to message #126534]

Tue, 05 July 2005 09:29

joemullins
Messages: 3
Registered: July 2005

Junior Member

So for example , on Shipment , I could notify a customer via email using Workflow?

How would I use PL/SQL documents ?

Report message to a moderator

Re: Sending Emails from E-Business Suite [message #126719 is a reply to message #126547]

Wed, 06 July 2005 06:23

adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway

Senior Member

A PL/SQL document is basically an attribute whose content is generated by a PL/SQL procedure returning an HTML or a text document. In Workflow you define a message attribute of type document and specify the PL/SQL procedure producing it.

How to do this is described in the "Oracle Workflow Developer's Guide" and the "Oracle Workflow API Reference". Both of these manuals can be found on the documentations CD available for download from either Metalink>Top Tech Docs or from OTN.

--
Aleksander Dragnes

Report message to a moderator

Previous Topic:	DFF
Next Topic:	Oracle API to retrieve data from Oracle Applation DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 10 09:19:45 CDT 2026