OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Oracle alert creation (alerts 11i)

Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle alert creation (alerts 11i) (Windows 7)

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

Oracle alert creation (alerts 11i) [message #613844]

Mon, 12 May 2014 22:25

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

Report message to a moderator

Re: Oracle alert creation (alerts 11i) [message #613845 is a reply to message #613844]

Mon, 12 May 2014 22:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: Oracle alert creation (alerts 11i) [message #613853 is a reply to message #613844]

Tue, 13 May 2014 01:23

John Watson
Messages: 8963
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

Report message to a moderator