Fixing running Oracle Reports from a menu item in Forms during upgrade

December 30, 2011

You may find that when you upgrade your forms application from client server. The reports you have that are run from the menu bar have stopped working. This is due to the change from using RUN_PRODUCT to using the RUN_REPORT_OBJECT() built-in.

In order to use the RUN_REPORT_OBJECT() built-in you need to have a report object in the form from which you want to call the report. If you need to add a report object across the board you can checkout some past posts for how to do form manipulations in patch either using JDAPI or Form to XML functionality. Full details of the solution is found in the below document.