Database Reference
In-Depth Information
SELECT S.TYPE, M.CHANNEL,M.SENDER, M.STATE, S.CONTENT FROM STATUS S, (SELECT A.VALUE SENDER, A.DELIVERY_TYPE CHANNEL, D.DELIVERY_STATE STATE, D.ADDRESS_ID FROM ADDRESS A, DELIVERY_ATTEMPT D WHERE A.ADDR_ID =D.ADDRESS_ID) M WHERE S.ADDRESS_ID=M.ADDRESS_ID AND M.STATE<>'SUCCESS';
The following screenshot shows an example of the output of the preceding
query:
Configuring multiple send addresses with UMS
Most definitely there will be practical scenarios where e-mail notification needs
to be distinguished based on
From Address
of e-mail. To understand this better,
assume there is one order confirmation BPEL process sending e-mails with the
From Address
set as
OrderStatus@yourcompany.com
, whereas a custom-
er rewards process may need to send e-mails with a different
From Address
such as
Customerservice@yourcompany.com
.
You must have observed that there is just one default
From Address
configured
for the e-mail driver on the infrastructure. Configuring multiple send addresses
is tricky but you may do it by following these steps (also illustrated in the next
screenshot):
1.
Log in to Oracle Enterprise Manager Fusion Middleware Control.
2.
Right-click on
soa-infra
and navigate to
Administration
|
System MBean
Browser
.
3.
Expand
Application Defined MBeans
|
oracle.as.soainfra.config
|
Serv-
er: server_name
|
HWFMailerConfig
|
human-workflow
.
4.
Click on the
Operations
tab and then on
setASNSDriver
.
5.
The
propertyName, propertyValue
, and
driverName
values have to be
entered
in
the
form.
Enter
EmailFromAddress,
Order-