{"id":6063,"date":"2023-11-28T10:00:49","date_gmt":"2023-11-28T09:00:49","guid":{"rendered":"https:\/\/promatis-test.de\/ch\/first-experience-with-e-business-suite-12-2-13-ecc-v11-upgrade\/"},"modified":"2023-12-11T10:11:46","modified_gmt":"2023-12-11T09:11:46","slug":"first-experience-with-e-business-suite-12-2-13-ecc-v11-upgrade","status":"publish","type":"post","link":"https:\/\/promatis-test.de\/ch\/first-experience-with-e-business-suite-12-2-13-ecc-v11-upgrade\/","title":{"rendered":"First Experience with E-Business Suite 12.2.13 \/ ECC V11 Upgrade"},"content":{"rendered":"<p>[et_pb_section fb_built=\"1\" custom_padding_last_edited=\"on|tablet\" disabled_on=\"off|off|off\" admin_label=\"Sektion\" _builder_version=\"4.17.6\" _module_preset=\"default\" custom_padding=\"5vh||5vh||true|false\" custom_padding_tablet=\"5vh||5vh||true|false\" custom_padding_phone=\"5vh||5vh||true|false\" global_module=\"6064\" locked=\"off\" global_colors_info=\"{}\" theme_builder_area=\"et_body_layout\"][et_pb_row column_structure=\"1_4,3_4\" _builder_version=\"4.17.6\" _module_preset=\"default\" custom_margin=\"||0px||false|false\" global_colors_info=\"{}\" theme_builder_area=\"et_body_layout\"][et_pb_column type=\"1_4\" _builder_version=\"4.17.6\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"et_body_layout\"][et_pb_image src=\"https:\/\/promatis.com\/wp-content\/uploads\/2022\/07\/johannes-michler.png\" alt=\"Johannes Michler PROMATIS Horus Oracle\" title_text=\"johannes-michler\" _builder_version=\"4.20.2\" _module_preset=\"default\" width=\"90%\" custom_margin=\"0vh||0vh||true|false\" border_radii=\"on|516px|516px|516px|516px\" global_colors_info=\"{}\" theme_builder_area=\"et_body_layout\"][\/et_pb_image][\/et_pb_column][et_pb_column type=\"3_4\" _builder_version=\"4.17.6\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"et_body_layout\"][et_pb_text ul_type=\"square\" _builder_version=\"4.23.1\" _module_preset=\"default\" text_font=\"Open Sans||||||||\" link_font=\"Open Sans||||on|||gcid-0becd5ff-19fc-4653-a221-c8c75771a987|\" link_text_color=\"gcid-0becd5ff-19fc-4653-a221-c8c75771a987\" link_font_size=\"22px\" ul_font=\"Open Sans||||||||\" ul_font_size=\"17px\" ul_line_height=\"1.6em\" header_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_2_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_2_line_height=\"1.6em\" header_3_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_4_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_5_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_6_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_6_font_size=\"16px\" custom_margin=\"2vh||0px||false|false\" custom_padding=\"||||true|false\" hover_enabled=\"0\" 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%22link_text_color%22%93}\" theme_builder_area=\"et_body_layout\" sticky_enabled=\"0\"]<\/p>\n<div><a href=\"\/.\/de\/author\/jmichler\/\" rel=\"author\">Johannes Michler<\/a><\/div>\n<p>[\/et_pb_text][et_pb_text ul_type=\"square\" _builder_version=\"4.20.0\" _module_preset=\"default\" text_font=\"Open Sans||||||||\" link_font=\"Open Sans||||on||||\" link_text_color=\"#00A9A0\" ul_font=\"Open Sans||||||||\" ul_font_size=\"17px\" ul_line_height=\"1.6em\" header_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_2_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_2_line_height=\"1.6em\" header_3_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_4_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_5_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_6_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" 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=\"et_body_layout\"]<\/p>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2023\/02\/ACE-Director-Logo_175x51.jpg\" \/><br \/><strong>Executive Vice President<\/strong> \u2013\u00a0Head of Platforms\u00a0&\u00a0Development<\/p>\n<p>[\/et_pb_text][et_pb_text ul_type=\"square\" _builder_version=\"4.20.0\" _module_preset=\"default\" text_font=\"Open Sans||||||||\" 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_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_2_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_2_line_height=\"1.6em\" header_3_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_4_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_5_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_6_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" 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=\"et_body_layout\"]<a target=\"_blank\" href=\"https:\/\/www.linkedin.com\/in\/johannes-michler-099892ab?originalSubdomain=de\" rel=\"noopener\"><i class=\"fab fa-linkedin\"><\/i><\/a><a target=\"_blank\" href=\"https:\/\/www.xing.com\/profile\/Johannes_Michler3\" rel=\"noopener\"><i class=\"fab fa-xing-square\"><\/i><\/a><a target=\"_blank\" href=\"mailto:johannes.michler@promatis.de\" rel=\"noopener\"><i class=\"fas fa-envelope\"><\/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=\"et_body_layout\"][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=\"et_body_layout\"][et_pb_column type=\"4_4\" _builder_version=\"4.16\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"et_body_layout\"][et_pb_text _builder_version=\"4.23.1\" _module_preset=\"default\" background_enable_color=\"off\" custom_padding=\"0px||0px||true|false\" hover_enabled=\"0\" 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=\"et_body_layout\" sticky_enabled=\"0\"]<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/promatis.com\/de\/wp-content\/uploads\/2023\/12\/ebs_12213_eccv11upgrade.png\" width=\"1764\" height=\"366\" alt=\"\" class=\"wp-image-5532 alignnone size-full\" \/><\/p>\n<p>Last week, I've upgraded the E-Business Suite of a first customer to the latest E-Business Suite RUP 12.2.13, Enterprise Command Centers V11 as well as Database 19.21.<\/p>\n<p>A comprehensive list of the new features is available over here: <a href=\"https:\/\/www.oracle.com\/a\/ocom\/docs\/applications\/ebusiness\/ebs-12-2-13-and-ecc-november-2023.pdf\" target=\"_blank\" rel=\"noopener\">https:\/\/www.oracle.com\/a\/ocom\/docs\/applications\/ebusiness\/ebs-12-2-13-and-ecc-november-2023.pdf<\/a><\/p>\n<h2>Symptoms of Issue while applying the patch<\/h2>\n<p>While\/after applying the main 12.2.13 patch (34776655) unfortunately the instance broke down terribly. The issues that we were seeing were:<\/p>\n<ul>\n<li>Oracle Forms could no longer be opened. The following error was shown:<\/li>\n<\/ul>\n<pre>Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.<\/pre>\n<ul>\n<li>Enterprise Command Centers can no longer be used. In the eccManaged Server we see logs as follows:<\/li>\n<\/ul>\n<pre>Caused by: java.lang.RuntimeException: java.sql.SQLException: ORA-01017: invalid username\/password; logon denied\n\nat oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:920)\nat oracle.apps.fnd.security.DBConnObj.getLabelledConnection(DBConnObj.java:298)<\/pre>\n<ul>\n<li>The same error can also be seen with trivial dbc-based connection tests<\/li>\n<li>Since all that suggests there are issues with the APPS-Password, I then tried to change the APPS\/APPLSYS\/APPS_NE password using AFPASS. That gives:<\/li>\n<\/ul>\n<pre>[oracle@master230703app01 ~]$ date; AFPASSWD -s APPLSYS; date\nWed Nov 22 13:11:02 CET 2023\nEnter the ORACLE password of Application Object Library 'APPSUSER':\nConnected successfully to APPS.\nError in password verification for APPS\nAFPASSWD completed with errors.\nWed Nov 22 13:11:06 CET 2023<\/pre>\n<ul>\n<li>Using the \u201colder\u201d tool to change the passwords FNDCPASS was similar:<\/li>\n<\/ul>\n<pre>oracle@master230703app01 ~]$ FNDCPASS APPS\/AbCdEfG 0 Y EBS_SYSTEM\/Secret1234 SYSTEM APPLSYS MYNEWPWD\nLog filename : L858096.log\n\nReport filename : O858096.out\n[oracle@master230703app01 ~]$ cat L858096.log\n+---------------------------------------------------------------------------+\nApplication Object Library: Version : 12.2\n\nCopyright (c) 1998, 2013, Oracle and\/or its affiliates. All rights reserved.\n\nFNDCPASS:\n+---------------------------------------------------------------------------+\n\nCurrent system time is 21-NOV-2023 00:19:40\n\n+---------------------------------------------------------------------------+\n\nArguments\n\nFNDCPASS EBS_SYSTEM\/***** SYSTEM APPLSYS *****\n+----------------------------------------------------------------------------+\nWorking...\nError in password verification for APPS\n\n+---------------------------------------------------------------------------+\nConcurrent request completed\nCurrent system time is 21-NOV-2023 00:19:40\n\n+---------------------------------------------------------------------------+<\/pre>\n<ul>\n<li>Checking if the E-Business Suite Concurrent Managers are up also fails:<\/li>\n<\/ul>\n<pre>[oracle@master230703app01 ~]$ adcmctl.sh status\n\nYou are running adcmctl.sh version 120.19.12020000.7\n\nEnter the APPS username : apps\n\nEnter the APPS password :\nCannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.\nInternal Concurrent Manager status could not be determined.\n\nadcmctl.sh: exiting with status 0\n\nadcmctl.sh: check the logfile \/u01\/install\/APPS\/fs2\/inst\/apps\/MAST_mastebsapp01\/logs\/appl\/admin\/log\/adcmctl.txt for more information ...<\/pre>\n<p>All those issues suggest, that something is broken with the Vault.<\/p>\n<h2>Cause<\/h2>\n<p>All those issues started even during the application of the patch; so even before the cutover phase the \u201crun\u201d edition of the E-Business Suite got broken.<\/p>\n<p>A lot of analysis together with the E-Business Suite development team at Oracle revealed, that the problem is related with us having:<\/p>\n<ol>\n<li>The sec_case_sensitive_logon database parameter is set to FALSE. So this means, that password checking on the DB is not done case sensitive<\/li>\n<li>However, the APPS\/APPLSYS\/APPS_NE password on that instance has previously been set to a mixed case Password (aBcDeFgH instead of ABCDEFGH). While this is not a problem in normal 12.2.12 and AD\/TXK 15 operation, somehow the patch stumbles over this.<\/li>\n<\/ol>\n<p><strong>Be aware:<\/strong> We've been \"rather lucky\" that the instance were we first realized this was not PROD. Even if you do all your testing first on a Dev\/Test instance you might hit this issue only on PROD. Just think about having APPS as the APPS-Password on Dev\/Test (I've heard of that ? ) and then having something FaNcY as the PROD password. Then the Dev\/Test works perfect but on PROD you break the PROD even before you start your planned downtime for the ADOP Cutover.<\/p>\n<h2>Solution A: Fix before upgrade<\/h2>\n<p>If you\u2019ve got a valid backup that you can easily restore probably the easiest approach to fix this is:<\/p>\n<ul>\n<li>Before applying the 12.2.13 patch change the password to something \u201call uppercase\u201d (e.g. MYPWD) using AFPASSWD. See <a href=\"https:\/\/docs.oracle.com\/cd\/E26401_01\/doc.122\/e22954\/T202991T174305.htm#522325\" target=\"_blank\" rel=\"noopener\">https:\/\/docs.oracle.com\/cd\/E26401_01\/doc.122\/e22954\/T202991T174305.htm#522325<\/a> for all details.<\/li>\n<li>Optionally ( I did this, I don\u2019t think though that it is necessary) enable sec_case_sensitive_logon to TRUE and (further) optionally change the password back to something with mixed case for better security.<\/li>\n<li>Only then apply the patch and it should go through without issues.<\/li>\n<\/ul>\n<h2>Solution B: If you're already screwed up<\/h2>\n<p>If your instance is already patched and \u201cnow broken\u201d you can probably file a SR and mention that you\u2019re running into the bug 36040277; the dev team can then provide you a temporary package that allows to change the APPS Password and thus repair the instance \/ the Vault.<em><\/em><\/p>\n<h2>Summary<\/h2>\n<p>Beside of this, all the patches as part of 12.2.13, AD\/TXK 15 and ECC V11 could be applied without any issues \u2013 which proves again that the entire process and system in the meantime is very stable and those yearly RUPs are really not too big a deal to apply.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Johannes MichlerExecutive Vice President \u2013\u00a0Head of Platforms\u00a0&#038;\u00a0Development Last week, I've upgraded the E-Business Suite of a first customer to the latest E-Business Suite RUP 12.2.13, Enterprise Command Centers V11 as well as Database 19.21. A comprehensive list of the new features is available over here: https:\/\/www.oracle.com\/a\/ocom\/docs\/applications\/ebusiness\/ebs-12-2-13-and-ecc-november-2023.pdf Symptoms of Issue while applying the patch While\/after applying [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1243,"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-6063","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-techblog"],"_links":{"self":[{"href":"https:\/\/promatis-test.de\/ch\/wp-json\/wp\/v2\/posts\/6063"}],"collection":[{"href":"https:\/\/promatis-test.de\/ch\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/promatis-test.de\/ch\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/wp-json\/wp\/v2\/comments?post=6063"}],"version-history":[{"count":0,"href":"https:\/\/promatis-test.de\/ch\/wp-json\/wp\/v2\/posts\/6063\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/wp-json\/wp\/v2\/media\/1243"}],"wp:attachment":[{"href":"https:\/\/promatis-test.de\/ch\/wp-json\/wp\/v2\/media?parent=6063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/wp-json\/wp\/v2\/categories?post=6063"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/wp-json\/wp\/v2\/tags?post=6063"},{"taxonomy":"dipi_cpt_category","embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/wp-json\/wp\/v2\/dipi_cpt_category?post=6063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}