Order and Service Management (Communications Industry) (MOSC)
Discussions
Oracle Event Alert firing multiple times
edited Feb 14, 2012 11:56PM in Order and Service Management (Communications Industry) (MOSC) 1 comment
Hi
I have an Event Alert which needs to fired when the order gets" CANCELLED"
but to my surprise it is firing multiple times for particular order
Alert Type : Event
Table : OE_ORDER_HEADERS_ALL
AFTER UPDATE
Code:
SELECT distinct ORDER_NUMBER
INTO
&L_ORDER_NUMBER
FROM OE_ORDER_HEADERS_ALL
WHERE ROWID=:ROWID
AND UPPER(FLOW_STATUS_CODE) = 'CANCELLED'
AND cancelled_flag='Y'
I have an Event Alert which needs to fired when the order gets" CANCELLED"
but to my surprise it is firing multiple times for particular order
Alert Type : Event
Table : OE_ORDER_HEADERS_ALL
AFTER UPDATE
Code:
SELECT distinct ORDER_NUMBER
INTO
&L_ORDER_NUMBER
FROM OE_ORDER_HEADERS_ALL
WHERE ROWID=:ROWID
AND UPPER(FLOW_STATUS_CODE) = 'CANCELLED'
AND cancelled_flag='Y'
0