Propel Your Business

How to resolve FRM-41214 Error Trying to Run Reports From Forms 12c Using RUN_REPORT_OBJECT Built-in

How to resolve FRM-41214 Error Trying to Run Reports From Forms 12c Using RUN_REPORT_OBJECT Built-in

FRM-41214 Error Trying to Run Reports From Forms 12c Using RUN_REPORT_OBJECT Built-in

Titleimage

Posted by RENAPS Dev Team on 2024:06:10 19:13:36

Applicable to Oracle Forms and Reports: Version 12.2.1.0.0 and later

Information in this document applies to any platform. Applies to Oracle Reports Developer - Version 12.2.1.0.0 to 12.2.1.0.0 [Release 12c], Oracle Forms - Version 12.2.1.0.0 and later, Oracle Forms for OCI - Version 12.2.1.4.0 and later

Please note that as of January 2023, Premier Support for Fusion Middleware 12c (including Oracle Forms 12c) will end in December 2026 (with Extended Support following, ending in December 2027). With Premier Support near EOL, this product is no longer entitled to the following:

  • New updates, fixes, security alerts, data fixes, and critical patch updates
  • New tax, legal, and regulatory updates
  • New upgrade scripts
  • Certification with new third-party products/versions
  • Certification with new Oracle products

If your organisation is impacted by this change, please consider an Oracle Forms Upgrade to latest version or an Oracle Forms Migration to Java/React with ORMIT™ Open Java.

Oracle Forms & Reports: Symptoms of the issue

Trying to call reports from forms 12c using RUN_REPORT_OBJECT() built-in fails with the following error:

FRM-41214 Unable to run report

After clicking on the OK button from the above error, the following error is displayed in the message bar:

FRM 41217 : Unable to get the report job status

Oracle Forms & Reports 12c: Changes & Causes

Changes

New installation and configuration of Forms/Reports 12c

Cause

A new environment variable is needed in Forms 12c to be able to call reports using RUN_REPORTS_OBJECT() built-in

Solution

Apply the following actions:

  1. Edit the Forms environment configuration file (Default: default.env, or whatever env file you may be using with your forms application.) using EM console.
  2. Add the following new variable: 
    COMPONENT_CONFIG_PATH=$DOMAIN_HOME/config/fmwconfig/components/ReportsToolsComponent/
    NB: Make sure you replace $DOMAIN_HOME or %DOMAIN_HOME% for the real value in above line. If you configured your Reports Server components using Note 2072671.1 then the name for will be "reptools1"
  3. Retest.

For applications that use the Oracle Forms built-in RUN_REPORT_OBJECT to integrate with Oracle Reports, it will be necessary to add a new environment variable to the Forms environment configuration (that is, default.env). The new variable name is COMPONENT_CONFIG_PATH and its value should be the fully qualified path to the Reports Tools Component. For example: $DOMAIN_HOME/config/fmwconfig/components/ReportsToolsComponent/

Posted by RENAPS Dev Team on 2024:06:10 19:13:36

Tags

Return to Blog

Back to the blog

Browse