{"id":8444,"date":"2016-05-13T10:11:59","date_gmt":"2016-05-13T14:11:59","guid":{"rendered":"https:\/\/pitss.org\/us\/?p=8444"},"modified":"2018-05-23T19:04:03","modified_gmt":"2018-05-23T23:04:03","slug":"frm-93652-forms-12c","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2016\/05\/13\/frm-93652-forms-12c\/","title":{"rendered":"FRM-93652 Errors Caused by Running Certain Forms in 12c"},"content":{"rendered":"<p>[et_pb_section fb_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; admin_label=&#8221;Row&#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; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_text admin_label=&#8221;Text&#8221; _builder_version=&#8221;3.0.106&#8243; custom_margin=&#8221;||30px|&#8221;]<\/p>\n<p>There is a bug in Forms 12c where the Forms application crashes with FRM-93652 errors when calling any forms where data from a record group is populated. Oracle has created a patch to fix this problem.<\/p>\n<p>[\/et_pb_text][et_pb_divider color=&#8221;#e2e2e2&#8243; divider_position=&#8221;center&#8221; disabled_on=&#8221;on|on|off&#8221; admin_label=&#8221;Divider&#8221; _builder_version=&#8221;3.2&#8243; custom_css_main_element=&#8221;margin-bottom:30px !important;&#8221;][\/et_pb_divider][et_pb_text admin_label=&#8221;Text&#8221; _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>\u00a0Step-by-step tutorial to implement the patch<br \/> <strong style=\"font-size: 16px; padding-right: 5px; background-color: #ffffff; color: #abd25e;\">\u2713<\/strong><span style=\"font-size: 16px; background-color: #ffffff;\">\u00a0Other patches that may be required<\/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_position_1=&#8221;top_left&#8221; background_repeat_1=&#8221;no-repeat&#8221; admin_label=&#8221;Row&#8221; _builder_version=&#8221;3.0.51&#8243; background_color=&#8221;#006bb3&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;no-repeat&#8221;][et_pb_text admin_label=&#8221;Text&#8221; _builder_version=&#8221;3.0.106&#8243; background_color=&#8221;#006bb3&#8243; background_layout=&#8221;dark&#8221;]<\/p>\n<h2 style=\"font-size: 30px! important;\"><strong>Fill out the form below to access this blog post.<\/strong><\/h2>\n<p>[\/et_pb_text][et_pb_code admin_label=&#8221;Code&#8221; module_class=&#8221;white-text&#8221; _builder_version=&#8221;3.3.1&#8243;][ninja_form id=43][\/et_pb_code][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=&#8221;0px||0px|&#8221; custom_margin=&#8221;30px||0px|&#8221; background_position_1=&#8221;top_left&#8221; background_repeat_1=&#8221;no-repeat&#8221; admin_label=&#8221;Row&#8221; _builder_version=&#8221;3.0.51&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;no-repeat&#8221;][et_pb_cta title=&#8221;Why do businesses need digital transformation?&#8221; button_url=&#8221;https:\/\/https:\/\/pitss.org\/digital-transformation-for-legacy-systems\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;DIGITAL TRANSFORMATION FOR LEGACY SYSTEMS&#8221; admin_label=&#8221;Call To Action&#8221; _builder_version=&#8221;3.3.1&#8243; background_color=&#8221;#222222&#8243; custom_button=&#8221;on&#8221; button_font=&#8221;Abel|||on|&#8221; text_orientation=&#8221;left&#8221; custom_padding=&#8221;45px|50px|45px|50px&#8221; border_style=&#8221;solid&#8221;]CIOs in organizations around the world saw their revenue and operational efficiency increase by 37% in 2016. Would your business benefit from 37% more revenue?[\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There is a bug in Forms 12c where the Forms application crashes with FRM-93652 errors when calling any forms where data from a record group is populated. Oracle has created a patch to fix this problem.What you&#8217;ll learn in this article: \u2713\u00a0Step-by-step tutorial to implement the patch \u2713\u00a0Other patches that may be requiredFill out the [&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>There is a bug in Forms 12c where the Forms application crashes with FRM-93652 errors when calling any forms where data from a record group is populated. Oracle has created a patch to fix this problem. These steps should be followed to fix this problem:<\/p><p>NOTE: This problem is currently only seen in Unix environments (Linux, Solaris, AIX, etc.). It has not been reported in Windows.<\/p><ol><li>Download Oracle Patch <strong>21534616<\/strong> from My Oracle Support. Make sure to download the version for your server's OS. NOTE: The patch is technically an Oracle Database patch, version 11.2.0.3.0, but this will be used to patch the DB client which comes with the Forms 12c installation.<\/li><li>Extract the patch in your server. Once it is extracted, navigate into the 21534616 folder.<\/li><li>Make sure the following environment variables are set (this assumes the Oracle home is installed in \/oracle\/middleware\/as_1 but it may be different for your environment)<ul><li>export ORACLE_HOME=\/oracle\/middleware\/as_1<\/li><li>export PATH=\/oracle\/middleware\/as_1\/bin:$PATH:\/oracle\/middleware\/as_1\/OPatch<\/li><\/ul><\/li><li>Run <strong>opatch prereq CheckConflictAgainstOHWithDetail -ph .\/<\/strong> to make sure there are no conflicts or errors. <a href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-1.png\"><img class=\"alignnone size-full wp-image-8445\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-1.png\" alt=\"FRM-93652 1\" width=\"641\" height=\"81\" \/><\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <a href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-2.png\"><img class=\"alignnone size-full wp-image-8446\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-2.png\" alt=\"FRM-93652 2\" width=\"642\" height=\"353\" \/><\/a><\/li><li>Shut down all instances inside the Forms 12c domain (all WebLogic servers, OHS, the standalone reports server, and Node Manager).<\/li><li>Run <strong>opatch apply<\/strong> to install the patch.\u00a0 <a href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-3.png\"><img class=\"alignnone size-full wp-image-8447\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-3.png\" alt=\"FRM-93652 3\" width=\"344\" height=\"17\" \/><\/a><\/li><li>Make sure the Middleware Home is the Oracle Home for Forms 12c. If it is, type <strong>y<\/strong> to proceed.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <a href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-4.png\"><img class=\"alignnone size-full wp-image-8448\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-4.png\" alt=\"FRM-93652 4\" width=\"640\" height=\"336\" \/><\/a><\/li><li>When it asks if the local system is ready for patching, type <strong>y<\/strong> and press Enter.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <a href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-5.png\"><img class=\"alignnone size-full wp-image-8449\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-5.png\" alt=\"FRM-93652 5\" width=\"641\" height=\"161\" \/><\/a><\/li><li>You should receive a message that the patch was successfully applied. There will be some warnings, but you may ignore these warnings.<a href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-6.png\"><img class=\"alignnone size-full wp-image-8450\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-6.png\" alt=\"FRM-93652 6\" width=\"641\" height=\"388\" \/><\/a><\/li><li>Go to $ORACLE_HOME\/forms\/lib and run the following command:<ul><li><strong>make -f ins_forms.mk frmweb_install<\/strong><\/li><li><strong>\u00a0<\/strong><strong><a href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-7.png\"><img class=\"alignnone size-full wp-image-8451\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-7.png\" alt=\"FRM-93652 7\" width=\"504\" height=\"35\" \/><\/a><\/strong><\/li><\/ul><\/li><li>If you see the output shown in the following screenshot, the step was run successfully.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <a href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-8.png\"><img class=\"alignnone size-full wp-image-8452\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/FRM-93652-8.png\" alt=\"FRM-93652 8\" width=\"641\" height=\"389\" \/><\/a><\/li><li>Start up your Forms 12c environment.<\/li><li>Recompile all forms, menus, and libraries.<\/li><\/ol><p>After applying the steps above, you should no longer encounter FRM-93652 errors when opening up any 12c forms where data from a record group is populated.<\/p><p>NOTE: There is a possibility that you may encounter the error <strong>FRM-41337<\/strong> in the same forms. If you do, you will need to apply another Oracle patch as indicated in <a href=\"https:\/\/pitss.org\/us\/2016\/05\/06\/frm-41337-appears\/\">https:\/\/pitss.org\/us\/2016\/05\/06\/frm-41337-appears\/<\/a>.<\/p>","_et_gb_content_width":"","footnotes":""},"categories":[22,14,19],"tags":[89,51,32,25,12,3,23,17,45],"class_list":["post-8444","post","type-post","status-publish","format-standard","hentry","category-forms","category-resolve-issues","category-unix-linux","tag-12c","tag-aix","tag-bug","tag-customer-support-request","tag-error","tag-faq","tag-forms","tag-linux","tag-solaris"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/8444","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=8444"}],"version-history":[{"count":12,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/8444\/revisions"}],"predecessor-version":[{"id":11403,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/8444\/revisions\/11403"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=8444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=8444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=8444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}