[\/et_pb_text][et_pb_text ul_type=\"square\" _builder_version=\"4.20.0\" _module_preset=\"default\" link_font=\"Open Sans||||on||||\" link_text_color=\"#00A9A0\" ul_font=\"Open Sans||||||||\" ul_font_size=\"17px\" ul_line_height=\"1.6em\" header_2_line_height=\"1.6em\" header_6_font_size=\"16px\" custom_margin=\"1vh||0px||false|false\" custom_padding=\"||||true|false\" text_font_size_tablet=\"20px\" text_font_size_phone=\"17px\" text_font_size_last_edited=\"on|tablet\" header_font_size_tablet=\"\" header_font_size_phone=\"28px\" header_font_size_last_edited=\"on|phone\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22%93}\" theme_builder_area=\"post_content\"]<\/p>\n
[\/et_pb_text][et_pb_text ul_type=\"square\" _builder_version=\"4.20.0\" _module_preset=\"default\" text_text_color=\"gcid-0becd5ff-19fc-4653-a221-c8c75771a987\" text_font_size=\"22px\" link_font=\"Open Sans||||on||||\" link_text_color=\"#00A9A0\" ul_font=\"Open Sans||||||||\" ul_font_size=\"17px\" ul_line_height=\"1.6em\" header_2_line_height=\"1.6em\" header_6_font_size=\"16px\" custom_margin=\"5px||0px||false|false\" custom_padding=\"||||true|false\" text_font_size_tablet=\"20px\" text_font_size_phone=\"17px\" text_font_size_last_edited=\"on|tablet\" header_font_size_tablet=\"\" header_font_size_phone=\"28px\" header_font_size_last_edited=\"on|phone\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22%93,%22gcid-0becd5ff-19fc-4653-a221-c8c75771a987%22:%91%22text_text_color%22%93}\" theme_builder_area=\"post_content\"]<\/i><\/a><\/i><\/a><\/i><\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\"1\" _builder_version=\"4.16\" _module_preset=\"default\" custom_padding=\"0vh||10vh||false|false\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_row use_custom_gutter=\"on\" _builder_version=\"4.17.3\" _module_preset=\"default\" custom_padding=\"0px||0px||true|false\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_column type=\"4_4\" _builder_version=\"4.16\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_text _builder_version=\"4.25.1\" _module_preset=\"default\" background_enable_color=\"off\" custom_padding=\"0px||0px||true|false\" inline_fonts=\"Times New Roman\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22%93,%22gcid-0becd5ff-19fc-4653-a221-c8c75771a987%22:%91%22background_color%22%93}\" theme_builder_area=\"post_content\"]<\/p>\n In the recent months, a lot of our customers have migrated from MS Exchange on Premise to Exchange online. A main challenge that causes is, that with Exchange Online it is no longer possible to sign in to send and receive Emails using Username and Password. Instead, an OAuth-Sign-In Flow is required.<\/p>\n The following Oracle Support note describes the basic procedure: Configuring Oracle Workflow for OAuth 2.0 in Oracle E-Business Suite Release 12.2 and Release 12.1.3 (Doc ID 2884072.1) describes the steps in very much detail. From a high level perspective, you have to:<\/p>\n I'll refrain from replicating everything here but instead focus on troubleshooting and common pitfalls.<\/p>\n When implementing this with multiple customers we repeatedly ran into the issue that the Exchange Online \/ Azure team did not follow the Oracle documentation by the letter. Especially keep note of the sentences written in BOLD. Oracle has done a great job in writing this document, however still in more than 50% of the customers I've been working with errors have been made.<\/p>\n There is a quite good way to troubleshoot though. Basically, you have to download OAuthIMAPTest.class from 2860542.1 and can then run something like:<\/p>\n The magic numbers are the .p12 and the .cer file (in that order) file_ids that you can find as follows:<\/p>\n If all goes well that should end with:<\/p>\n If something goes wrong with that tool you get at least some better errors than through the \"Test\" in the UI.<\/p>\n Migrating the IMAP (and also the SMTP) postbox behind E-Business Suite Workflow Mailer from MS Exchange to Office 365 \/ Exchange Online is straightforward. If your security considerations allow it, you can even use a common Azure App that is allowed both the PROD and the TEST mailboxes and thus can fully automate the cloning by just changing the s_javamailer_outbound_user and s_javamailer_imap_user of the Context file.<\/p>\n Keep in mind that there may be more places you need to adjust, e.g. an Oracle SOA Suite Environment or BI Publisher Bursting or custom utl_smtp functionality.<\/p>\n Due to upcoming changes regarding outbound (mass) E-Mails of MS Exchange Online you may be better off not sending them through Exchange Online anyways though. I'll write another blog post on both SOA Suite and alternative SMTP Server (e.g. within Oracle OCI) shortly.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" In this blog post we will give you an overview for Oracle E-Business Suite Workflow Mailer when migrating to Exchange Online.<\/p>\n","protected":false},"author":2,"featured_media":1234,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[23],"tags":[],"dipi_cpt_category":[],"class_list":["post-5847","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-techblog"],"_links":{"self":[{"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/posts\/5847"}],"collection":[{"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/comments?post=5847"}],"version-history":[{"count":0,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/posts\/5847\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/media\/1234"}],"wp:attachment":[{"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/media?parent=5847"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/categories?post=5847"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/tags?post=5847"},{"taxonomy":"dipi_cpt_category","embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/dipi_cpt_category?post=5847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![](\"\/.\/at\/wp-content\/uploads\/2023\/02\/ACE-Director-Logo_175x51.jpg\"){kind=logo}
Executive Vice President<\/strong> \u2013\u00a0Head of Platforms\u00a0&\u00a0Development<\/p>\n![\"\"](\"https:\/\/promatis.com\/de\/wp-content\/uploads\/2024\/06\/migrating-to-exchange-online-01.jpg\")
<\/p>\nConfiguration for E-Business Suite<\/h2>\n
\n
Testing and Troubleshooting<\/h2>\n
source \/u01\/install\/APPS\/EBSapps.env run;\n\n\n$AFJVAPRG -classpath .:$AF_CLASSPATH OAuthIMAPTest wf-ebs-entw@customer.de d0b7d37d-9b04-4b05-aadf-a9fc74614d18 https:\/\/login.microsoftonline.com\/f9a4fdf3-3ad9-4855-b1b1-b96763b022c1\/oauth2\/v2.0\/token https:\/\/outlook.office365.com\/.default 31065893 31065894 secret $FND_SECURE\/$TWO_TASK.dbc MicrosoftOffice365ExchangeOnline\n<\/pre>\n
select file_name,file_id from fnd_lobs where file_name like '%p12' or file_name like '%cer';<\/pre>\n
![\"\"](\"https:\/\/promatis.com\/de\/wp-content\/uploads\/2024\/06\/migrating-to-exchange-online-02.jpg\")
Successful connection<\/em><\/p>\n<\/ul>\n
Summary<\/h2>\n