Upgrading Reports Manually in Oracle Forms

You can also perform specific steps to manually upgrade Reports in Oracle Forms.

You can use the Forms Migration Assistant described in About Using the Oracle Forms Migration Assistant to change integrated Reports calls in your Oracle Forms modules. The 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 run-time engine in Forms 6i.

To manually upgrade 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 Oracle Forms 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.
   For more information on how to use the RUN_REPORT_OBJECT built-in, review the Form Builder Help.