Bug of the Week: FRM-41214 – Unable to Run Reports 10g From Forms 11g

Now that I’ve been doing upgrades to 11g R2 for the last 6 months, I am starting to see all types of architectures and have been getting special requests. This week one of my customers asked me to migrate the forms to 11gR2 but to keep the reports on the 10.1.2.3 servers. While doing this, I found this week’s ‘bug of the week‘.  An annoying one to find but fortunately it already has a patch all ready to go.
Running the reports from the Forms from the outset was not a problem. The reports were able to run as long as the two servers shared a common IP subnet. You can check which Oracle Reports bridges are configured and running in the subnet using the rwdiag utility. For example, run the following command:
/bin/rwdiag -findall
You should get a list of all the reports servers that were discovered.
For example (from Oracle):
Broadcast mechanism used to locate servers 
------------------------   
Channel address = 228.5.6.7 Channel port = 14021 
(1) Name = bugupdate : Type = server : Host = strep15.idc.oracle.com 
(2) Name = rep_sup: Type = server : Host =sup-pc.idc.oracle.com 
(3) Name = rep_stre : Type = server : Host = stre.idc.oracle.com 
However, after the report was run without a problem and we could see the PDF in the browser, we got the following popup error message:  FRM-41214 – Unable to run Report . It was quite annoying but, fortunately, we quickly found the bug: Running Reports 10.1.2.3 with Forms 11g.
 
This interoperability scenario requires the Patch 7597820 to be installed on the Reports 10.1.2.3 ORACLE_HOME.You can download this patch from the following URL:
http://updates.oracle.com/download/7597820.html This patch is required to address the CORBA IDL changes between the two releases for the Job Status information. If you want to use rwservlet of Reports 10g Release 2 (10.1.2.3) with the Reports 11g Release 1 (11.1.1) Server, ensure that you install this patch on your 10.1.2.3 installation.You can download this patch from http://metalink.oracle.com.
It is also well documented in the Oracle® Fusion Middleware Publishing Reports to the Web with Oracle Reports Services:
http://download.oracle.com/docs/cd/E17904_01/bi.1111/b32121/pbr_verify006.htm
The patch takes only about 3 minutes to install since it requires a report server restart.

Conclusion and Resources:

Have you encountered this bug? Let me know if my tip helped – email me at info@auraplayer.com

  1. If you want to run Forms without an applet at all from HTML or mobile apps this page is a good place to start.
  2. Want assistance from the industry experts in Oracle Forms? AuraPlayer has free “ask our experts” sessions available, click here to schedule.
  3. In addition, if you want to learn how to stay in control of your Oracle Forms environment and applications, read our Essential Guide to troubleshooting errors on Oracle Forms – Download Now
Bug of the Week: FRM-41214 – Unable to Run Reports 10g From Forms 11g
Article Name
Bug of the Week: FRM-41214 – Unable to Run Reports 10g From Forms 11g
Description

Now that I’ve been doing upgrades to 11g R2 for the last 6 months, I am starting to see all types of architectures and have been getting special requests. This week one of my customers asked me to migrate the forms

Author
Publisher Name
auraplayer
Publisher Logo

David Buch
Senior Products Manager

David, our Senior Products Manager, is a highly experienced professional specializing in product definition, innovations, and development, with broad customer understanding, and skillful people management. He has over 20 years of R&D work experience, and continues to excel in his expertise. Before starting his career, David attended Bar-Ilan University where he studied computer science and economics. When he is not working, David enjoys spending his time as a professional tuba player joining symphony orchestras and chamber ensembles.

Elizabeth Pearl
Relationship Manager

A Relationship Manager, but a teacher by degree, Elizabeth is passionate about technology and always seeks to educate and improve the lives of others. During her years as a teacher, Elizabeth learned valuable skills that she applies to everyday life and her role at AuraPlayer: active listening, organization, preparation, and clear communication. Elizabeth is originally from the United States but currently resides in England. In her spare time, she loves exercising, spending time with her family and friends, and playing volleyball.

Nathalie Wasserman
CFO & Operations Manager

Natalie is proud to be AuraPlayer’s Operations and Chief Financial Officer. She takes pride in her work, and loves being a part of the AuraPlayer family. Prior to working at AuraPlayer, Nathalie worked at various companies as an accountant. She attended the University College London (UCL), where she graduated with a Bachelor’s Degree in economics and business. She then went on to pursue a Master’s degree in Political Economies in Eastern Europe. 

Gwen Edwards
VP Business Development

An expert in helping businesses seize their potential and grow, Gwen is committed to take AuraPlayer to the next level. With over 30 years of experience in the high technology sector and working with Fortune 500 companies, she works as an advisor for growing businesses to help enhance their value and reach their business objectives. She’s a dynamic member of our team, leveraging her sales and marketing, and P&L experience to our current and future product suite.

Gwen also serves on a several private company boards in Silicon Valley, and is an active member of the angel investment network, Golden Seeds.

Yossi Nakash
CTO & Co-Founder

A true developer, Yossi has been developing and coding in Java / J2EE, C++, .Net, and C# for over 15 years, focusing mainly on the RD side of things. Entering the Oracle World about 5 years ago, Yossi immersed himself in the world of Oracle SOA, Weblogic, ADF and ADF Mobile, as well as the Java side of things.

Prior to joining Mia to found AuraPlayer, Yossi held the role of RD team leader at RadView and was a Java developer at Motorola.