{"id":8427,"date":"2016-05-06T09:48:57","date_gmt":"2016-05-06T13:48:57","guid":{"rendered":"https:\/\/pitss.org\/us\/?p=8427"},"modified":"2017-05-12T15:06:58","modified_gmt":"2017-05-12T19:06:58","slug":"running-oracle-reports-12c-causes-frm-41214-errors","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2016\/05\/06\/running-oracle-reports-12c-causes-frm-41214-errors\/","title":{"rendered":"Running Oracle Reports in 12c Causes FRM-41214 Errors"},"content":{"rendered":"<p>After upgrading Oracle Forms and Reports from a previous version (e.g. 10g or 11g) to 12c, there is a known issue where running Oracle Reports in 12c with the RUN_REPORT_OBJECT built-in causes the following error:<\/p>\n<p>&#8220;FRM-41214: Unable to run report&#8221;<\/p>\n<p>Starting in Forms 12c, a new environment variable, CONFIGURE_COMPONENT_PATH, has been created. This should be placed in your environment file (.env) used by your Forms application. The variable should be mapped to the location of your ReportsToolsComponent. You may either edit the file manually or create a new variable under Environment Configuration for the Forms instance in EM FMW Control.<\/p>\n<p>Example: CONFIGURE_COMPONENT_PATH=%DOMAIN_HOME%\\config\\fmwconfig\\components\\ReportsToolsComponent\\reptools1<\/p>\n<p><a href=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/COMPONENT_CONFIG_PATH.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8428\" src=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/COMPONENT_CONFIG_PATH.png\" alt=\"COMPONENT_CONFIG_PATH\" width=\"910\" height=\"343\" srcset=\"https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/COMPONENT_CONFIG_PATH.png 910w, https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/COMPONENT_CONFIG_PATH-300x113.png 300w, https:\/\/pitss.org\/us\/wp-content\/uploads\/sites\/4\/2016\/05\/COMPONENT_CONFIG_PATH-768x289.png 768w\" sizes=\"auto, (max-width: 910px) 100vw, 910px\" \/><\/a><\/p>\n<p>NOTE: If you use EM FMW Control to create or modify your environment variables for Forms, it is highly recommended to continue to use EM FMW Control.<\/p>\n<p>In addition, make sure that the CLASSPATH variable has the full path to rwrun.jar (%ORACLE_HOME%\\reports\\jlib\\rwrun.jar), as this jar file is required to generate reports from Oracle Forms.<\/p>\n<p>After you have made the changes, re-launch the Forms application. You should now be able to run a report.<\/p>\n<p><strong>Source: Oracle Support note 2074841.1<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>After upgrading Oracle Forms and Reports from a previous version (e.g. 10g or 11g) to 12c, there is a known issue where running Oracle Reports in 12c with the RUN_REPORT_OBJECT built-in causes the following error: &#8220;FRM-41214: Unable to run report&#8221; Starting in Forms 12c, a new environment variable, CONFIGURE_COMPONENT_PATH, has been created. This should be [&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":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[22,4,36,14],"tags":[89,41,12,23,37],"class_list":["post-8427","post","type-post","status-publish","format-standard","hentry","category-forms","category-install-config","category-reports","category-resolve-issues","tag-12c","tag-configuration","tag-error","tag-forms","tag-reports"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/8427","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=8427"}],"version-history":[{"count":3,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/8427\/revisions"}],"predecessor-version":[{"id":9121,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/8427\/revisions\/9121"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=8427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=8427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=8427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}