Skip Headers

Oracle Forms Developer and OracleAS Forms Services Migrating Forms Applications from Forms 6i
10g (9.0.4)

Part Number B10469-01
Go To Documentation Library
Go To Table Of Contents
Go To Index

Go to previous page Go to next page

Integrating Reports and Graphics

Oracle Graphics6i is no longer shipped with Oracle Forms. In addition, the Charting wizard has been removed from Forms. This chapter describes how you can call existing Graphics6i and Reports applications from a form.

Oracle Graphics6i

You cannot create new charts because Oracle Graphics6i is no longer shipped with Oracle Forms. However, you can display existing charts in Forms and Reports applications that have been migrated.

The following whitepapers at provide additional information:

Displaying Existing Charts in Oracle Forms

If your form contains embedded Oracle Graphics6i displays, you can still display them in Oracle Forms by doing the following:

Editing Existing Chart Items

You can edit the properties of existing Oracle Forms chart items, create new Oracle Forms chart items in Forms Developer, and populate an Oracle Forms chart item with an OGD file that was created in Oracle Graphics6i Developer. However, future releases of Forms may further restrict Graphics6i functionality.

Since Oracle Graphics was not originally conceived for Web deployment, issues may arise when forms with embedded charts are re-deployed from a client-server environment to the Web, particularly more complex charts with more complex character sets. In some cases, text dimensions may alter, causing text items to overlap or to extend over the edge of a display. These issues, particularly concerning scaling, are akin to the side effects that can occur when porting applications from one platform to another. Recommendations on how to deal with these issues can be found in Deploying Oracle Graphics in Oracle9iAS V2 Forms Services at

Migration to the Web of forms with embedded Oracle Graphics displays may well entail modifications to modules. Allow time to check the behavior of each embedded chart on the Web, and decide if any of the suggestions in the white paper need to be implemented. See how the chart looks with the largest set of data it is likely to be passed, not just a small set of test data (good practice whether running in a client-server environment or on the Web). Consider whether reports deployment may be preferable in some cases. Review the charts to see if there are any items that can be removed, particularly redundant axes labels or legends. If you are migrating forms with embedded OGDs from client-server deployment to Oracle9iAS on the Web, it would be best to break this down into two stages. First migrate to Forms Services 6i Web deployment and then upgrade to Oracle9iAS. In this way, you can deal with any Oracle Graphics Web-migration issues in the 6i environment in which you still have Graphics Builder and the Chart Wizard. Nevertheless, in the second stage, the upgrade to Oracle9iAS, check out the appearance of your charts once again.

About Integration with Oracle Reports

You can embed new and existing Reports applications in forms that have been migrated to Oracle Forms.

You can no longer use the Reports client runtime engine to output Reports in the Web. From Forms50 forward, the RUN_REPORT_OBJECT Built-in is available in Forms Developer to run integrated reporting in Forms. The RUN_PRODUCT Built-in is obsolete in Oracle Forms for running Oracle Reports applications from Oracle Forms.

Oracle9i Forms and Oracle Reports are now Web-based only, and do not have client/server runtime engines. Therefore, integrated reports in Oracle Forms applications must be recoded to use the RUN_REPORT_OBJECT Built-in and Oracle Application Server Reports Services.

For additional information about integrating Oracle Forms with Reports, see Integrating Oracle9iAS Reports in Oracle9iAS Forms at the Oracle Technology Network at

Displaying Reports in Oracle Forms

If your form contains embedded Oracle Reports applications, you can migrate the form to Oracle Forms by changing the integrated call to Oracle Reports to use:

Using RUN_PRODUCT in Oracle9i Forms to run integrated Oracle Reports is no longer supported in Oracle9i Forms. The Oracle9i Forms Migration Assistant is provided to help you migrate your applications to use Run_Report_Object. See Chapter 2, "Using the Oracle Forms Migration Assistant" for more information.


The following example runs a report using the RUN_REPORT_OBJECT Built-in. The report_object node defined in Forms Developer is assumed to be "report_node1". A user-defined Reports parameter "p_deptno" is passed by Forms using the value in the "dept.deptno" field. The Reports parameter form is suppressed. For additional details about the logic used in this example, see Notes About the Example.

/* The following example runs a report using the RUN_REPORT_OBJECT Built-in. The 
report_object node defined in Forms Developer is assumed to be "report_node1". A 
user-defined Reports parameter "p_deptno" is passed by Forms using the value in 
the "dept.deptno" field. The Reports parameter form is suppressed */

 v_report_id 		Report_Object;
 vc_report_job_id  		VARCHAR2(100); 	/* unique id for each Report 	 request */
 vc_rep_status      		VARCHAR2(100);		 /* status of the Report job */
 	/* Get a handle to the Report Object itself. */
 	v_report_id:= FIND_REPORT_OBJECT('report_node1');
 /* Define the Report output format and the name of the Reports Server as well 
as a user-defined parameter, passing the department number from Forms to the 
Report. The Reports parameter form is suppressed by setting  paramform  to "no". 
 	/* replace <ReportServerTnsName> with the name of the Reports9i Services as 
defined in your tnsnames.ora file */
 	SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER, '<ReportServerTnsName>');
  	/* finally, run the report and retrieve the Reports job_id as a handle to the 
Reports process */
 /*The report output is not delivered automatically to the client, which is okay 
because the Web is a request model. Thus the next step is to check if the report 
finished. */
 	vc_rep_status := REPORT_OBJECT_STATUS(vc_report_job_id);
 	IF vc_rep_status='FINISHED' THEN
 /* Call the Report output to be displayed in a separate browser window. The URL 
for relative addressing is only valid when the Reports Server is on the same 
host as the Forms Server. For accessing a Remote Reports Server on a different 
machine, you must use the prefix http://hostname:port/ */
 web.show_document ('/<virtual path>/<reports cgi or servlet name>/getjobid='|| 
vc_report_job_id ||'?server='|| '<ReportServerTnsName>','_blank');
 	message ('Report failed with error message '||rep_status);

Notes About the Example

Using Parameter Lists in RUN_REPORT_OBJECT

Parameter lists that were used with RUN_PRODUCT in client-server mode can also be used with RUN_REPORT_OBJECT calling Oracle Application Server Reports Services. System parameters must be set by the Set_Report_Object_Property. The syntax for using parameter lists in RUN_REPORT_OBJECT is as follows:


where paramlist_id is the same id used with RUN_PRODUCT.

Parameter settings can be any of the following:

Other settings are as follows:

Migration Steps

You can use the Oracle9i Forms Migration Assistant described in Chapter 2, "Using the Oracle Forms Migration Assistant" to change integrated Reports calls in your Oracle Forms modules. The Oracle9i Forms Migration Assistant adds code to your application modules that redirects Run_Product calls to Reports and uses the Run_Report_Object Built-in and Reports Services. The resulting conversion is of the same quality as using Run_Product and the runtime engine in Forms 6i.

To manually migrate Reports in Oracle Forms, do the following:

  1. Find all occurrences of Run_Product.

  2. Identify and locate the parameter lists used with these calls.

  3. Remove all of the Reports system parameter settings like desname and destype from the parameter lists.

  4. Find the Reports node ID for the Reports node name defined in Forms Developer or the Forms 6i Builder.

  5. Create Set_Report_Object_Property codes for DESNAME, REPORT_SERVER, DESFORMAT, DESTYPE, COMM_MODE, and EXECUTION:MODE in your PL/SQL.

  6. Use Run_Report_Object(report_node_id, paramlist_id) to reuse your parameter lists that had been created for Run_Product.

    Note: Detailed information about how to change calls to Oracle Reports in Forms 6i to use Run_Report_Object are provided in a whitepaper on

Go to previous page Go to next page
Copyright © 2003, 2003 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Go To Index