Home » Applications » Oracle Fusion Apps & E-Business Suite » Event Based alert on a changing the values of a column (11.5.10.2)
Event Based alert on a changing the values of a column [message #287194] Tue, 11 December 2007 06:34 Go to next message
Mukulkant
Messages: 9
Registered: December 2007
Location: Delhi
Junior Member

Hi

There is a requirment for a alert in HR which is event based on PER_ALL_ASSIGNMENTS_F on change of the column ATTRIBUTE8 value.
There is one more event based alert on this table.
As this alert is specific to change in values of attribute8 so we are not getting any way how do we proceed for the creation.


Please any budy advise.


Regared
Mukul


Re: Event Based alert on a changing the values of a column [message #287254 is a reply to message #287194] Tue, 11 December 2007 12:36 Go to previous messageGo to next message
ggr88
Messages: 31
Registered: October 2007
Location: Wellington, New Zealand
Member
Hi Mukul,

Not sure if I understand your question, but you could
a) create event alert and then modify the (standard) trigger that is create to check only for the change in value of attribute8
b) turn on standard AuditTrail for that table for column attribute8 (and others required by your reporting) and use alert on that, or manual report to generate email.

Gareth
http://garethroberts.blogspot.com
Re: Event Based alert on a changing the values of a column [message #287336 is a reply to message #287254] Wed, 12 December 2007 00:35 Go to previous message
Mukulkant
Messages: 9
Registered: December 2007
Location: Delhi
Junior Member

Hi Thanks a lot for reply.

Sir,We can create event alert and then modify the (standard) trigger but the problem is if we have to create some other event based alert on diffrent column.Then This generic trigger will not work.so what we want is the seprate trigger for this alert.

Please advise...


Regards
Mukul
Previous Topic: How to bounce the workflow mailer
Next Topic: How to Edit Wf_mailer email Body
Goto Forum:
  


Current Time: Mon Dec 05 13:06:31 CST 2016

Total time taken to generate the page: 0.08154 seconds