Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle Alerts: Alerts on Multiple Rows (Oracle Apps EBS 12.2.6)
Oracle Alerts: Alerts on Multiple Rows [message #671512] Mon, 03 September 2018 08:41 Go to next message
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

Re: Oracle Alerts: Alerts on Multiple Rows [message #671514 is a reply to message #671512] Mon, 03 September 2018 09:23 Go to previous messageGo to next message
Michel Cadot
Messages: 66650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Oracle Alerts: Alerts on Multiple Rows [message #671515 is a reply to message #671514] Mon, 03 September 2018 10:02 Go to previous messageGo to next message
vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad
Member
Yes it is. There is a responsibility Alerts Manager, where alerts are created.
Re: Oracle Alerts: Alerts on Multiple Rows [message #671517 is a reply to message #671512] Mon, 03 September 2018 10:39 Go to previous messageGo to next message
BlackSwan
Messages: 26606
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.
Re: Oracle Alerts: Alerts on Multiple Rows [message #671518 is a reply to message #671517] Mon, 03 September 2018 11:01 Go to previous messageGo to next message
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.
Re: Oracle Alerts: Alerts on Multiple Rows [message #671519 is a reply to message #671518] Mon, 03 September 2018 11:12 Go to previous messageGo to next message
BlackSwan
Messages: 26606
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.
Re: Oracle Alerts: Alerts on Multiple Rows [message #671520 is a reply to message #671512] Mon, 03 September 2018 11:39 Go to previous message
John Watson
Messages: 8023
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.
Previous Topic: Oracle configurator - Model Migration
Next Topic: Oracle Web Adi: Table Details Not Loading in Interface Creation
Goto Forum:
  


Current Time: Mon Oct 21 20:42:58 CDT 2019