OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Oracle Alerts: Alerts on Multiple Rows

Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle Alerts: Alerts on Multiple Rows (Oracle Apps EBS 12.2.6)

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

Oracle Alerts: Alerts on Multiple Rows [message #671512]

Mon, 03 September 2018 08:41

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

Hello All,

I have a table with 4 columns: Roll_No, Name, DOB, Contact_Email. This table carries the data for a Class.

The requirement is to send a Private email alert to the email id in the Column Contact_Email, if SYSDATE = DOB, for each student separately.

I know I can do this using UTIL but I want to do it using Oracle Alerts.

I am not able to get how to send the alert when the query return multiple rows, meaning multiple students having birthday on the same date and I want to send individual emails to every student.

Thanks,
Vaibhav

Report message to a moderator

Re: Oracle Alerts: Alerts on Multiple Rows [message #671514 is a reply to message #671512]

Mon, 03 September 2018 09:23

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you sure this is an "Oracle Fusion Apps & E-Business Suite" question?

Report message to a moderator

Re: Oracle Alerts: Alerts on Multiple Rows [message #671515 is a reply to message #671514]

Mon, 03 September 2018 10:02

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

Yes it is. There is a responsibility Alerts Manager, where alerts are created.

Report message to a moderator

Re: Oracle Alerts: Alerts on Multiple Rows [message #671517 is a reply to message #671512]

Mon, 03 September 2018 10:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

vaibhav15211 wrote on Mon, 03 September 2018 06:41

Hello All,

I have a table with 4 columns: Roll_No, Name, DOB, Contact_Email. This table carries the data for a Class.

The requirement is to send a Private email alert to the email id in the Column Contact_Email, if SYSDATE = DOB, for each student separately.

SYSDATE is NOW.
DOB is always in the past.
SYSDATE will NEVER equal DOB; so no email should ever be sent.

Report message to a moderator

Re: Oracle Alerts: Alerts on Multiple Rows [message #671518 is a reply to message #671517]

Mon, 03 September 2018 11:01

vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad

Member

Consider that there is a comparison of only date and month. So when the birthday comes email should go.

Report message to a moderator

Re: Oracle Alerts: Alerts on Multiple Rows [message #671519 is a reply to message #671518]

Mon, 03 September 2018 11:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

vaibhav15211 wrote on Mon, 03 September 2018 09:01

Consider that there is a comparison of only date and month. So when the birthday comes email should go.

schedule a daily batch job to send email to those whose birthday is today.

Report message to a moderator

Re: Oracle Alerts: Alerts on Multiple Rows [message #671520 is a reply to message #671512]

Mon, 03 September 2018 11:39

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

I may be wrong (my EBS admin is a bit rusty) but I think you would do this with an Alert defined for a periodic frequency (every day) rather than for an event. It will need a SELECT that will capture all relevant students and send them to the workflow that will generate the emails.

Report message to a moderator

Previous Topic:	Oracle configurator - Model Migration
Next Topic:	Oracle Web Adi: Table Details Not Loading in Interface Creation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 15:13:03 CST 2024