Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle alert creation (alerts 11i) (Windows 7)
Oracle alert creation (alerts 11i) [message #613844] Mon, 12 May 2014 22:25 Go to next message
arunkrishnangs87
Messages: 4
Registered: May 2014
Location: India
Junior Member
Hi,

Can you please help me in creating a periodic alert. My requirements are:
The alert should be triggered last 10 days of a quarter (every 3 hours). In between the quarter, business used to perform soft quarter closure activities, so for that month too alert should be triggered for the last 10 days of the month(every 3 hours). This alert should send some data extracted by the query(alredy provided by the business user, but it will only extract the data) given to some users.

Regards,
Arun
Re: Oracle alert creation (alerts 11i) [message #613845 is a reply to message #613844] Mon, 12 May 2014 22:28 Go to previous messageGo to next message
BlackSwan
Messages: 22786
Registered: January 2009
Senior Member
welcome to this forum.

can you write SQL when you don't know table or column names? I can not do so.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/
Re: Oracle alert creation (alerts 11i) [message #613853 is a reply to message #613844] Tue, 13 May 2014 01:23 Go to previous messageGo to next message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
Should this thing you call an "alert" triggered by an event, or by schedule? It sounds like a scheduledd job to me, so no problem using the calendaring possibilities:
http://docs.oracle.com/cd/E16655_01/server.121/e17636/scheduse.htm#ADMIN12417
Re: Oracle alert creation (alerts 11i) [message #613867 is a reply to message #613853] Tue, 13 May 2014 04:07 Go to previous messageGo to next message
arunkrishnangs87
Messages: 4
Registered: May 2014
Location: India
Junior Member
Hi John,

This should be a periodic alert. Scheduled to run only during the last 10 days of the quarter (every 3 hours).

Thanks,
Arun
Re: Oracle alert creation (alerts 11i) [message #613879 is a reply to message #613867] Tue, 13 May 2014 06:11 Go to previous message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
So write is as a scheduled job, using an appropriate calendaring string.
Previous Topic: iRecruitment implementation
Next Topic: How can i hide the Action History section in a Customised workflow
Goto Forum:
  


Current Time: Wed Sep 17 17:05:50 CDT 2014

Total time taken to generate the page: 0.09726 seconds