This content has been marked as final. Show 7 replies
You have to define WHEN you want the alert to fire.
Is it upon CREATION ? Upon Approval?
Once you have identified the condition, you have to format the message.
Here is a great example http://docs.oracle.com/cd/A60725_05/html/comnls/us/alr/summary.htm.
It is for PO header and PO lines. You can use it - just change PO details to Req Details.
I know the condition. I am asking how to build the alert in the above(message) mentioned format.
Because event alert is for each exception.
For example see the alert message below, if we have two lines for one requisition the alert is firing two times for each line with same requisition number.
I want two lines and one requisition header in single alert notification.
Requisition Number : 14636
Description : ALet test
Line Num Description Quantity Unit Price Trx unit Price
-------- ----------- -------- ---------- --------------
=**= Enter summary template below this line =**=
** 2 Test 10 10 10
=**= Enter summary template above this line =**=
Try to write the alert on the req. header table.
And then user the formatting from the example listed earlier.
I want details from both header and line table.
You can write an alert on the header and include details from the lines.
Please go thru' the example that was provided earlier.
Leave about the query, i will take care of that.
My question is i have 2 records ex:
header || lnum || ldata || lcur
12 || 1 || a || usd
12 || 2 || b || eur
I want this to be displayed in mail as
Header : 12
Lnum || Ldata || lcur
1 || a ||usd
2 || b || eur
Thanks for all your response.
The solution is we can use summary as action level and display the line details with requstn number in the subject. so for each req the alert gets triggered with lines in the alert body.