Home » Applications » Oracle Fusion Apps & E-Business Suite » Event Alert (Oracle R12)
Event Alert [message #475969] Mon, 20 September 2010 05:04 Go to next message
moe_k
Messages: 18
Registered: November 2009
Location: Lebanon
Junior Member
Event Alert is not running.. I can't find it in the Requests..
No emails are being sent.. although if i make it periodic , it works properly.

table name: IBY_PAY_SERVICE_REQUESTS
Application: Payments

select statement:
SELECT CALL_APP_PAY_SERVICE_REQ_CODE
into &OUTPUT1
from iby_pay_service_requests
where rowid = :ROWID


everything is well defined..
I would appreciate your help Smile

[EDITED by LF: removed Poll that never existed]

[Updated on: Mon, 20 September 2010 06:16] by Moderator

Report message to a moderator

Re: Event Alert [message #476169 is a reply to message #475969] Tue, 21 September 2010 18:54 Go to previous messageGo to next message
skimmer333
Messages: 23
Registered: August 2010
Location: Adelaide, Australia
Junior Member
Hi,
In the Alert, select the Alert Details button.
Then select the Installations tab. Have you populated the Oracle ID and Operating Unit?

Cheers,
Russell H.
Re: Event Alert [message #476447 is a reply to message #476169] Thu, 23 September 2010 06:17 Go to previous messageGo to next message
moe_k
Messages: 18
Registered: November 2009
Location: Lebanon
Junior Member
Hi .. Yes I populated them.. but the alert is not working..
Any other idea?
Will the alert run if i updated/inserted a field on the table directly..? i.e. from toad
Re: Event Alert [message #486500 is a reply to message #476447] Thu, 16 December 2010 01:43 Go to previous messageGo to next message
aryanna
Messages: 44
Registered: July 2007
Member

hi moe_k,

"Will the alert run if i updated/inserted a field on the table directly..? i.e. from toad "


Can this?
Re: Event Alert [message #488447 is a reply to message #486500] Fri, 07 January 2011 08:38 Go to previous messageGo to next message
moe_k
Messages: 18
Registered: November 2009
Location: Lebanon
Junior Member
No it wont
Re: Event Alert [message #489237 is a reply to message #475969] Thu, 13 January 2011 22:31 Go to previous messageGo to next message
skimmer333
Messages: 23
Registered: August 2010
Location: Adelaide, Australia
Junior Member
Hi,
So, in the Event Details tab, is the application: Payments
and Table: IBY_PAY_SERVICE_REQUESTS ?
and the After Insert and After Update are ticket?
Lastly, when you select Verify, does it state it has successfully parsed?

Cheers,
Russ.
Re: Event Alert [message #489729 is a reply to message #489237] Tue, 18 January 2011 11:39 Go to previous message
aryanna
Messages: 44
Registered: July 2007
Member

Thanks moe_k

Yea u'r rite.. it'll not triggering Alert if direct insert or update into table using TOAD.

But my alert is successfully trigger when the realtime event occur during insert and update in apps. Razz

Thanks,
aryanna
Previous Topic: Create web server
Next Topic: Join gl_je_lines with iby_payments_all
Goto Forum:
  


Current Time: Mon Dec 23 11:33:36 CST 2024