Home » Applications » Oracle Fusion Apps & E-Business Suite » Dynamic alert recipient list (Oracle Alerts)
Dynamic alert recipient list (Oracle Alerts) [message #351302] Tue, 30 September 2008 04:37 Go to next message
alastair_wood
Messages: 21
Registered: September 2006
Location: UK
Junior Member
Hi,
At the moment we have multiple alerts firing to static recipient lists (as in Define Distribution Lists)

However I want to send an alert to a recipient that is identified by the output of the alert SQL.

Does anyone know if it's possible to do this, and what is needed in the To field to reference this data?

A very basic example would be using the following select as the alert statement (event alert):

select
full_name,
email address
from
hr.per_all_people_f

How can I send the alert to the email address result of the SQL?

Thanks in advance for any assistance
Re: Dynamic alert recipient list (Oracle Alerts) [message #351528 is a reply to message #351302] Wed, 01 October 2008 07:07 Go to previous messageGo to next message
alastair_wood
Messages: 21
Registered: September 2006
Location: UK
Junior Member
No problem, now sorted - didn't realise you could enter variables from the select into the recipient list and subject header.

Now tested and working okay Smile
Re: Dynamic alert recipient list (Oracle Alerts) [message #351796 is a reply to message #351528] Fri, 03 October 2008 04:01 Go to previous message
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
Member
Hi,
Even it will work for multiple emails also...
Did u try that?
Kittu.
Previous Topic: Problem in AP module
Next Topic: XML Pulisher Installation issue
Goto Forum:
  


Current Time: Sat Dec 07 06:38:23 CST 2024