Test mail for workflowmailer

classic Classic list List threaded Threaded
2 messages Options
big
Reply | Threaded
Open this post in threaded view
|

Test mail for workflowmailer

big
Hi,
On R12.2.4 , DB 11.2.0.4,  on AIX
When we send test mail for workflowmailer we receive only one mail. We are expected to receive 2.

We received Only: Action Required: PLSQL Message for Testing Workflow Notification Mailer

What should we enable to receive 2?



Thanks
Reply | Threaded
Open this post in threaded view
|

Re: Test mail for workflowmailer

ErmanArslansOracleBlog
Administrator
Check the mailer log.. Also check the related Worklfow mailer Framework web agent profiles and ensure you have the correct conf.. Also ensure the user that should receive the test emails have the proper preferences set for receiving the emails. Ensure your Mail Server doesn't block anything..

a query for checking some related profiles;

Check the agent profiles and check the node names..

select p.profile_option_name,v.profile_option_value,
decode(v.level_id,
10001,'SITE',
10002, (select 'App:'||a.application_short_name from fnd_application a
where a.application_id = v.level_value),
10003, (select 'Resp:'||f.RESPONSIBILITY_KEY from fnd_responsibility f
where f.responsibility_id = v.level_value),
10004, (select 'User:'||u.user_name from fnd_user u
where u.user_id = v.level_value),
10005, (select 'Server:'||n.node_name from fnd_nodes n
where n.node_id = v.level_value),
10006, (select 'Org:'||org.name from hr_operating_units org
where org.name = v.level_value),
'NOT SET') PROF_LEVEL
from
fnd_profile_options p,
fnd_profile_option_values v
where
p.profile_option_id = v.profile_option_id (+)
and p.application_id = v.application_id (+)
and p.profile_option_name in ('WF_MAIL_WEB_AGENT','APPS_FRAMEWORK_AGENT','ICX_FORMS_LAUNCHER');
select substr(node_name, 1, 20) node_name, server_address, substr(host, 1, 15) host,
substr(domain, 1, 20) domain, substr(support_cp, 1, 3) cp, substr(support_web, 1, 3) web,
substr(SUPPORT_DB, 1, 3) db, substr(VIRTUAL_IP, 1, 30) virtual_ip from fnd_nodes;


Ref: https://ermanarslan.blogspot.com/2014/08/ebs-122-notification-mailer.html
Additional ref: E-Busines Suite Workflow Steps To Troubleshoot The Java-based Workflow Notification Mailer (Doc ID 242941.1)

Normally 2 email should be sent by the mailer

(1) Action Required: OA Framework Message for Testing Workflow Notification Mailer
(2) Action Required: PLSQL Message for Testing Workflow Notification Mailer

So you don't review the OA Framework Message.. This seems related with the wf agent profiles...