Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling Report from Menu (Oracle Forms 11g)

jaramillJul 29 2010 — edited Aug 4 2010
I'm trying to call a report from a menu item in a menu (that is attached to a form) in Oracle Forms 11g directly and I'm having some difficulty. I know how to call a report from a form and everything works perfectly.

But since in a menu there is no item called "Report" to attach like there is in Forms, I followed on route which is to attach the "rp2rro" PL/SQL library on the menu file (mmb) and I also even did it on the form itself. Then when you convert a menu using the Forms Migration Assistant, it will comment out statements like "ADD_PARAMETER" and replace with calls to packaged procedures/functions from the package "rp2rro". I set all the parameters

RP2RRO.SETOTHERS('PARAMFORM=YES');
RP2RRO.SETDESTYPE('CACHE');
RP2RRO.SETDESFORMAT('PDF');
RP2RRO.SETCOMMUNICATIONMODE(SYNCHRONOUS);

then made the call to the report:

RP2RRO.RUN_PRODUCT(REPORTS, 'MYREPORT', SYNCHRONOUS, RUNTIME, FILESYSTEM, param_list_id, NULL);

but all i get is the error "FRM-41219: Cannot find report: invalid ID."

The Oracle documentation for integration reports in forms is for when you execute the report within a form not a menu item (that is attached to a form). Any clues?

My environment is:

Oracle (Database, Fusion Middleware) 11g - Red Hat Enterprise Linux 5
Web Browser - Internet Explorer 7 on Windows XP Professional

Thanks,
This post has been answered by François Degrelle on Jul 31 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2010
Added on Jul 29 2010
8 comments
6,834 views