Re: Workflow mailer OAF-based notifications and SSL terminated load balancer environment

Posted by ArtKuznetsov on Nov 02, 2020; 6:55am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Workflow-mailer-OAF-based-notifications-and-SSL-terminated-load-balancer-environment-tp8889p8953.html

Hi Erman,

thank you very much for the help! After deep research, we discovered that it was custom workflow message body generation that caused the error. There was a custom PLSQL procedure that generated email body, and it used APPS_FRAMEWORK_AGENT instead of WF_MAIL_WEB_AGENT. We changed the code, and now it works fine.

Workflow status diagram was fixed by Patch 8802559: 1OFF:8618975:11.5.10.6:WF STATUS DIAGRAM SHOULD OPTIONALLY USE WF: Workflow Mailer Framework Web Agent, that implements the same logic (use WF_MAIL_WEB_AGENT)

The only thing that keeps failing is view log files from OAF interface. I'm pretty sure it is a TLS issue, because our load balancer configured with TLS 1.2, but OeBS 11.5.10.2 with JDK6 is able to work with TLS 1.0 only. But this issue is not that crucial, so we keep it as is.

Thanks a lot again for your help!

Regards,
Artyom