Proactive insights, news and tips from Oracle Fusion Middleware Support. Learn Oracle from Oracle.

Integrating Oracle Reports with Oracle Forms

Alexandra David
Principal Technical Support Engineer

Oracle Forms and Reports 12c have been recently released. Everybody talked about it.

To call Oracle Reports from Oracle Forms application, the most secure approach is to use the RUN_REPORT_OBJECT built-in.  Because the user’s database connection is implicitly passed from Oracle Forms to Oracle Reports on the middle tier server, there is no risk of interception as when passed such information in a URL.  

Sample code and detailed information can be found in any of these documents:

White Paper: Integrating Oracle Forms 10g and Oracle Reports 10g
White Paper: Oracle Forms Services - Using Run_Report_Object to call Reports with a Parameter Form
White Paper: Oracle Fusion Middleware 11gR1 & 11gR2 -Integrating Oracle Reports with Oracle Forms

Specific to 12c version , a new environment variable is needed in Oracle Forms 12c to be able to call reports using RUN_REPORTS_OBJECT() built-in. 

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/<reports_tools_component_name>

From Forms point of view, it will be necessary to add the new environment variable to the Forms environment configuration (that is, default.env).

Read more about this in:
Oracle® Fusion Middleware Release Notes for Oracle Forms and Reports 12c
2.3.8 Oracle Reports Integration Requires New Environment Variable

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.