Posted by
ErmanArslansOracleBlog on
Oct 31, 2020; 10:01am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Workflow-mailer-OAF-based-notifications-and-SSL-terminated-load-balancer-environment-tp8889p8948.html
Okay , I have limited connectivity right now, so I will send you my comments and some reference documents.. Please take a look these documents and comment and try to find your way.
Please update me with the outcome.
-->
1)
It is may be related with the APPS_FRAMEWORK_AGENT.
What is the value of the profile option named APPS_FRAMEWORK_AGENT?
Note that, if the Application Framework Agent profile option is set to a virtual or load balancing server, one must explicitly set the WF: Workflow Mailer Framework Web Agent profile option to a specific physical Web Server host address that is non-load balanced.
Maybe..
2)
Also is this a new config? I mean is the Load Balancer configured according to the EBS? ( configuration on load balancer itself)
3)
**
Ref: What Should Be The Value Of Application Agent Profiles? (Doc ID 559232.1)
-> Make sure that a System Profile 'Application Framework Agent' (APPS_FRAMEWORK_AGENT) is setup to non-SSL URL.
4)
**
Ref: E-Business Suite Workflow Java Mailer Fails With Error 'UNEXPECTED:[SVC-GSM-WFMLRSVC' And 'oracle.apps.fnd.wf.mailer.NotificationFormatter.handleResEndTag' Due To Problem obtaining the HTML content oracle.apps.fnd.wf.common.HTTPClientException (Doc ID 367483.1)
---Note that, you already did that!
-> Customers using loadbalancers, etc that uses a virtual hostname you must use the URL of one of their iAS web servers in WF: Workflow Mailer Framework Web Agent profile option (WF_MAIL_WEB_AGENT).
5)
** LOOK AT THIS ONE -> it says rebuild the queue..
Ref: Java Notification Mailer Fails to Send Email Notifications from FormatterException with Framework Regions (Doc ID 339718.1)
To set the WF_MAIL_WEB_AGENT profile :
Stop Workflow Mailer and Agent Listener service
Change the "WF: Workflow Mailer Framework Web Agent" [WF_MAIL_WEB_AGENT] profile option to point to a physical Web Server host address that is non-load balanced.
Rebuild mailer queue with:
SQL>@$FND_TOP/patch/115/sql/wfntfqup.sql APPS <APPS schema passwd> APPLSYS
Start Workflow Mailer and Agent Listener service.
Test scenario with a new notification.
6)
You said " In addition, view logs (WF mailer, concurrent managers etc) from OAF interface doesn't work. "
This is interesting.. This also makes me think about the APPS_FRAMEWORK_AGENT and the configuration in the load balancer side
Check -> Note:217368.1 - Advanced Configurations and Topologies for EBS 11i -> Option 2.2. HTTP Layer Hardware Load Balancing