{"id":10114,"date":"2017-09-14T11:19:34","date_gmt":"2017-09-14T15:19:34","guid":{"rendered":"https:\/\/pitss.org\/us\/?p=10114"},"modified":"2018-05-14T09:13:45","modified_gmt":"2018-05-14T13:13:45","slug":"oracle-forms-reports-12-2-1-3-0-information","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2017\/09\/14\/oracle-forms-reports-12-2-1-3-0-information\/","title":{"rendered":"Oracle Forms and Reports 12.2.1.3.0 Information and Findings"},"content":{"rendered":"<p>[et_pb_section bb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;3.0.51&#8243; custom_padding=&#8221;0px||50px|&#8221;][et_pb_row custom_padding=&#8221;0px|||&#8221; _builder_version=&#8221;3.0.51&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243;][et_pb_text _builder_version=&#8221;3.2.2&#8243; custom_margin=&#8221;||30px|&#8221; border_style=&#8221;solid&#8221;]<\/p>\n<h1 style=\"margin-bottom: 11px; font-size: 34px;\">Information and Findings of Oracle Forms and Reports 12.2.1.3.0<\/h1>\n<p>Oracle Forms and Reports 12.2.1.3.0 is the latest patchset release for Oracle Forms and Reports 12c which was released in August 2017. This article contains Oracle Forms and Reports 12.2.1.3.0 information and findings as well as important information to consider before you patch your existing Forms 12c environment to the latest version.<\/p>\n<p>[\/et_pb_text][et_pb_divider color=&#8221;#e2e2e2&#8243; show_divider=&#8221;on&#8221; divider_position=&#8221;center&#8221; disabled_on=&#8221;on|on|off&#8221; _builder_version=&#8221;3.0.51&#8243; custom_css_main_element=&#8221;margin-bottom:30px !important;&#8221; \/][et_pb_text _builder_version=&#8221;3.0.51&#8243; custom_margin=&#8221;||30px|&#8221;]<\/p>\n<h3><strong>What you&#8217;ll learn in this article:<\/strong><\/h3>\n<p><strong style=\"font-size: 16px; padding-right: 5px; background-color: #ffffff; color: #abd25e;\">\u2713<\/strong>\u00a0New updates and features in\u00a0Oracle Forms and Reports 12.2.1.3.0<br \/> <strong style=\"font-size: 16px; padding-right: 5px; background-color: #ffffff; color: #abd25e;\">\u2713<\/strong><span style=\"font-size: 16px; background-color: #ffffff;\">\u00a0Similarities between\u00a0Oracle Forms and Reports 12.2.1.3.0 and previous releases<\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=&#8221;40px|40px|30px|40px&#8221; background_color=&#8221;#006bb3&#8243; background_position_1=&#8221;top_left&#8221; background_repeat_1=&#8221;no-repeat&#8221; _builder_version=&#8221;3.0.51&#8243;][et_pb_column type=&#8221;4_4&#8243;][et_pb_text background_layout=&#8221;dark&#8221; _builder_version=&#8221;3.0.64&#8243; background_color=&#8221;#006bb3&#8243;]<\/p>\n<h2><strong>Fill out this form to get immediate access to the article.<br \/>\n<\/strong><\/h2>\n<p>[\/et_pb_text][et_pb_code module_class=&#8221;white-text&#8221; _builder_version=&#8221;3.0.73&#8243;][ninja_form id=25][\/et_pb_code][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Information and Findings of Oracle Forms and Reports 12.2.1.3.0 Oracle Forms and Reports 12.2.1.3.0 is the latest patchset release for Oracle Forms and Reports 12c which was released in August 2017. This article contains Oracle Forms and Reports 12.2.1.3.0 information and findings as well as important information to consider before you patch your existing Forms [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"<p>Oracle Forms and Reports 12.2.1.3.0 is the latest patchset release for Oracle Forms and Reports 12c which was released in August 2017. This article contains Oracle Forms and Reports 12.2.1.3.0 information and findings as well as important information to consider before you patch your existing Forms 12c environment to the latest version.<\/p><h3><strong>NEW UPDATES<\/strong><\/h3><p>For what we have seen on Oracle\u2019s website and Oracle Support, the following has been updated in the latest version of Oracle Forms 12c (12.2.1.3):<\/p><ul><li>Many bugs have been fixed (See\u00a0<a href=\"https:\/\/docs.oracle.com\/middleware\/12213\/formsandreports\/releasenotes-fnr\/bugs-fixed-this-release.htm#FRREL-GUID-959E2A14-BA5A-40ED-8838-0AD1036A507D\">the full list of bug fixes<\/a> for more details)<\/li><li>Only Oracle WebLogic Server (WLS) 12.2.1.3.0 is supported<\/li><li>Operating System Support:<ul><li>IBM-AIX: 7.1 UL1+ or 7.2<\/li><li>Linux: RHEL\/Oracle Linux 6 UL6+, RHEL\/Oracle Linux 7, SUSE 11 SP3+, or SUSE 12 SP1+<\/li><li>Solaris: 11 Update 2+ (SPARC or x86_64)<\/li><li>Windows:<ul><li>Deployment Server: 2012, 2012 R2, 2016<\/li><li>Development Clients: 7, 8.1, 10<\/li><\/ul><\/li><\/ul><\/li><li>JDK Support:<ul><li>JDK 1.8.0_131 or higher<\/li><li>JDK 6 or 7 are not supported<\/li><\/ul><\/li><li>Internet Browser Support:<ul><li>Google Chrome: 60+<\/li><li>Internet Explorer (IE): 11<\/li><li>Microsoft Edge: 40<\/li><li>Mozilla Firefox: 52+<\/li><li>Safari: 9, 10<\/li><li>NOTE: The NPAPI plugin (used by the Java Runtime Environment (JRE) for the Java browser plugin) is not usable in the Firefox, Chrome, and Microsoft Edge browsers. <a href=\"https:\/\/pitss.org\/us\/2017\/07\/18\/oracle-forms-12c-and-java-8\/\">Please read this article<\/a> by PITSS for more information regarding Oracle Forms and the Java browser plug-in.<\/li><\/ul><\/li><li>Database Support:<ul><li>11.2.0.4+<\/li><li>12.1.0.1+<\/li><li>12.2.0.1+<\/li><\/ul><\/li><li>OAM Support:<ul><li>Oracle Access Management 11gR2 (11.1.2.3.0)<\/li><li>Oracle Access Management 12c (12.2.1.3.0)<\/li><li>Oracle Internet Directory 11g (11.1.1.7.0 or 11.1.1.9.0)<\/li><li>Oracle Internet Directory 12c (12.2.1.3.0)<\/li><\/ul><\/li><li>Forms 12.2.1.3.0 must be installed as a new Oracle home even if you are patching from an older release of Oracle Forms 12c (12.2.1.x). Once the 12.2.1.3.0 binaries are installed, you may choose to either configure a new domain or to upgrade the existing 12c domain.<\/li><\/ul><p>For more information regarding Oracle Forms 12c certifications, please review Oracle\u2019s certification matrix for Forms and Reports 12c: <a href=\"http:\/\/www.oracle.com\/technetwork\/middleware\/fmw-122130-certmatrix-3867828.xlsx\">http:\/\/www.oracle.com\/technetwork\/middleware\/fmw-122130-certmatrix-3867828.xlsx<\/a><\/p><h3><strong>SIMILARITIES\/DIFFERENCES TO PREVIOUS FORMS 12C RELEASES<br \/> <\/strong><\/h3><p>After successfully installing and configuring Oracle Forms and Reports 12.2.1.3 in both our Windows 7 64-bit and Oracle Linux 6 64-bit test environments, we found that there are no major functionality changes which we could detect. In our test installations, we worked with Oracle WebLogic Server 12.2.1.3 using JDK 1.8.0_144 (<b>this was the latest JDK available for download as of September 2017 when the test installs were performed<\/b>).<b> <\/b>Based off the installation and configuration, we have noticed the following:<\/p><ol><li>The general installation procedure for installing the latest patchset of Oracle Forms and Reports 12c has not changed from previous 12c releases.<\/li><li>A new RCU schema for WebLogic Services (<PREFIX>_WLS) is required in addition to the already required schemas for Common Infrastructure Services (STB), Oracle Platform Security Services (OPSS), Audit Services (IAU), Audit Services Append (IAU_APPEND), and Audit Services Viewer (IAU_VIEWER). If you are upgrading from an older 12c release, you will need to run RCU again to install the WebLogic Services schema.<\/li><li>New to Forms 12.2.1.3, there is an optional feature called Forms Application Deployment Services (FADS). FADS allows you to package, deploy, and configure application deployments easily using its web interface as well as check the status of each deployment and update\/delete any existing applications. A standalone installation of Oracle SQL Developer is required to use this feature. Whether FADS will prove to be useful or just a \"fad\", the only way to find out is to try it out for yourself!<\/li><li>Unlike previous releases of Forms 12c, you will now be able to use JavaScript when launching Oracle Forms with Java Web Start and the Forms Standalone Launcher (FSAL). For this to work, you will need to download Jetty from Eclipse, sign the jar file with trusted code signing certificates, and deploy it in your Forms configuration.<\/li><li>Oracle Forms 12.2.1.3.0 is the first Oracle Forms release with support for both Oracle Access Management (OAM) 12c and Oracle Internet Directory (OID) 12c. OAM 11gR2 and OID 11g are still supported.<\/li><li>Similar to Forms and Reports 11g and older 12c releases, we still receive the <b>\u201cREP-52262<\/b><b>: Diagnostic output is disabled<\/b><b>\u201d <\/b>error when we try to run reports. In previous releases of Oracle Forms & Reports 11g, using the default setting in rwservlet.properties would allow anyone to access anything related to rwservlet such as getjobid, showjobs, showenv, etc. For some reason in 12c, the default settings act the same as using <webcommandaccess>L0<\/webcommandaccess> in the file. To fix this, we have to manually add the parameter <webcommandaccess>L2<\/webcommandaccess> into rwservlet.properties and restart WLS_REPORTS before we can view generated reports. <b>NOTE: If this was fixed manually in an older 12c Forms release and you upgrade the domain to 12.2.1.3, you do <u>not<\/u> have to redo this.<\/b> More information regarding this error and the solution may be found in our knowledge base article, <a href=\"https:\/\/pitss.org\/us\/2012\/12\/20\/running-reports-in-formsreports-11-1-2-1-generates-rep-52262-with-default-settings\/\">\"Running Reports in Forms\/Reports 11.1.2.1 Generates REP-52262 with Default Settings<\/a>.\"<\/li><li><strong>IMPORTANT: <\/strong>Unlike previous Forms 12c releases, Forms 12.2.1.3.0 is <span style=\"text-decoration: underline;\"><strong>NOT<\/strong><\/span> backwards compatible with previous Forms 12c releases. This means that if you save a form in Forms 12.2.1.3, it cannot be run in an older Forms 12c release such as 12.2.1.2. In addition, a form which was saved and compiled in Forms 12.2.1.2 or older will not be able to run in Forms 12.2.1.3 unless it is saved and compiled in Forms 12.2.1.3. This is because the new release contains new Required Support Files (RSFs) which change the behavior of Oracle Forms as well as the new features introduced in this version. As a result, if you plan to upgrade to the latest Forms 12c version, all your servers and clients must be upgraded around the same time to avoid any compatibility problems. For more information, please see Oracle Support Document ID <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?id=2256898.1\"><strong>2256898.1<\/strong><\/a>.<\/li><li>Like earlier releases of Oracle Forms and Reports 12c (12.2.1.0 to 12.2.1.2), WebUtil for Forms 12.2.1.3 uses Jacob 1.18-M2. No changes to the Jacob DLLs are required.<\/li><\/ol><h3><strong>ORACLE REPORTS DEPRECIATION<br \/> <\/strong><\/h3><p>With the release of Oracle Forms and Reports 12.2.1.3.0, this will be the terminal release of Oracle Reports. As of the new release, Oracle Reports has now been depreciated. Please note that this does not mean that it is no longer supported as it will continue to be covered under Premier Support along with Oracle Forms 12c until October 2020. With the depreciation, no new features have been added to Oracle Reports and will not be added. Only critical bugs will be patched in Oracle Reports. All Oracle Reports files will continue to run normally in 12.2.1.3.0 as they have in previous 12c releases. However, as premier support is only available for three more years, now is the perfect time to start planning your Oracle Reports modernization and digital transformation. There are many technologies available for reporting. As Oracle has stated in the Oracle Reports statement of direction, Oracle advises to migrate from Oracle Reports to Oracle BI Publisher. Oracle Forms 12c is compatible and supported with Oracle BI Publisher. <span id=\"kmPgTpl:r1:0:ol22\" class=\"p_AFHoverTarget xq\"><\/span>Our tool, PITSS.CON, is able to analyze your Oracle Reports to determine how much effort it will take to migrate your Oracle Reports to BI Publisher. <a href=\"https:\/\/pitss.org\/products\/pitss-con\/\">Learn more how PITSS.CON can help you with your migration of Oracle Reports to BI Publisher as well as the other great features PITSS.CON can do for you<\/a>.<\/p><p><strong>Source: <a href=\"http:\/\/docs.oracle.com\/middleware\/12213\/formsandreports\/releasenotes-fnr\/whats-new-this-release.htm#FRREL-GUID-C42AD398-3FAD-46CF-9AF4-D0C64008D5FD\">http:\/\/docs.oracle.com\/middleware\/12213\/formsandreports\/releasenotes-fnr\/whats-new-this-release.htm#FRREL-GUID-C42AD398-3FAD-46CF-9AF4-D0C64008D5FD<\/a><\/strong><\/p>","_et_gb_content_width":"","footnotes":""},"categories":[26,22,4,6,36,19,10],"tags":[89,51,23,13,17,46,7,37,45,43,20,40,24],"class_list":["post-10114","post","type-post","status-publish","format-standard","hentry","category-development","category-forms","category-install-config","category-pitss-con","category-reports","category-unix-linux","category-windows","tag-12c","tag-aix","tag-forms","tag-installation-setup","tag-linux","tag-ohs","tag-pitss-con","tag-reports","tag-solaris","tag-unix-based","tag-upgrade","tag-weblogic","tag-windows"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/10114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=10114"}],"version-history":[{"count":16,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/10114\/revisions"}],"predecessor-version":[{"id":11308,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/10114\/revisions\/11308"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=10114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=10114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=10114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}