OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Event Alert (Oracle R12)

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

Event Alert [message #475969]

Mon, 20 September 2010 05:04

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

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.

Report message to a moderator

Re: Event Alert [message #476447 is a reply to message #476169]

Thu, 23 September 2010 06:17

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

Report message to a moderator

Re: Event Alert [message #486500 is a reply to message #476447]

Thu, 16 December 2010 01:43

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?

Report message to a moderator

Re: Event Alert [message #488447 is a reply to message #486500]

Fri, 07 January 2011 08:38

moe_k
Messages: 18
Registered: November 2009
Location: Lebanon

Junior Member

No it wont

Report message to a moderator

Re: Event Alert [message #489237 is a reply to message #475969]

Thu, 13 January 2011 22:31

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.

Report message to a moderator

Re: Event Alert [message #489729 is a reply to message #489237]

Tue, 18 January 2011 11:39

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

Report message to a moderator

Previous Topic:	Create web server
Next Topic:	Join gl_je_lines with iby_payments_all

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 21:05:29 CDT 2025