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

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.

 

Reports_menu_from_Forms.zip

More code snippets: JDAPI: change Font for all Items, Prompts, Boilerplates, Frames

Its me again with more code samples to help batch upgrade for your application.

If my previous posts of how to convert the system to XML pages to then do manipulations in notepad was not for you. This is a different route to solve the same problems. Here is sample code of a java api that can manipulate forms in batch and change the font for all items.

Font_change_JDAPI.zip

NOTE:219168.1 – How To Change Fonts For All Items in a Form Module using JDAPI

Metalink is full of these little gems if you know where to look.

Don’t forget to follow us here and via Twitter (right here – top right)

We’ve got many more code snippets & tricks coming up!

Getting the Browser Window under control when separateFrame=True

To follow up with my post about closing the parent browser while running forms on the web I will share a few more tricks on how to control the browser window when running forms in separate frame mode.

These notes all basically use javascript to manipulate or minimize the effect the browser window has on the user.Attached is a great script on how to permanently minimize the browser window using javascipt and the below note can be found on Metalink:

Note 259786.1 Using Java To Manipulate The External Forms Frame For Application Running In separateFrame Mode

Minimize_Window.zip

Oracle Forms and Reports Installation Guide for IAS 10.1.2.3

Installing an Oracle IAS server for Hebrew support can be very tricky. With so many things to remember and so many steps to configure all the various parts registry, configuration files, language settings etc…Attached is a install guide with complete installation instructions in Hebrew on how to do just that!

To install the 10.1.2.3 IAS server you will need:
1) Oracle Application Server 10g Release 2 (10.1.2.0.2) -http://www.oracle.com/technology/software/products/ias/htdocs/101202.html

2) Download from Metalink patch for Oracle Application Server  10.1.2.3 – התקנת Patch 5983622 לגרסה – 10.1.2.3.0

Along with the word document: InstallGuideiASServer.zip

Good Luck!

If you have any questions or problems please comment below.

Mia

How can I close the parent browser window while running forms on the web?

I get this question a lot from customers who upgraded for the web.

“How to close the parent browser window when running Oracle Forms? When a forms application is web deployed the parent browser window remains opens after exit_form. Is it possible to close the browser window programatically?“

We see that once we are running on the web all of the sudden instead of one window popping up when we run the system we now have this troublesome second window.

Below is a simple script that I have found that can be very helpful on how to automatically close the browser window when the user exits the forms system.

Close_Window.zip

If you have additional Oracle Forms questions or comments, please let me know, I’ll try my best to help out and maybe feature the answer on one of the upcoming posts.

Follow me here (click on the follow button on the right) or via my twitter account @miaurman

 

Pluggable Java Components & Java Beans’ library

Although I know that every forms developer whose ever moved to the web probably knows about this blog
http://forms.pjc.bean.over-blog.com I could not imagine having a blog without a link to this incredible resource.

It is a one stop shop for every and all PJC’s and java beans with great how to documents on how they can be implemented in your forms. I myself go into the blog about every 2 weeks just to checkout the cool new java beans available.

Webutil Developer Install Guide Made Easy

This is a handy note on how to attach webutil in you applications. Although it looks simple follow the steps in order since something as silly as the order object appear can give really scary error messages.

Comment if you have any questions

UsingWebUtilinApplications.zip

Batch Script for FMB to XML and XML to FMB

Below you can download my script that can convert all the Forms modules in a specific directory to XML and vice a versa.

This is a neat trick to help you search and replace things in the forms. For example you can check properties of specific items, change field lengths and seacrh for links to external items in batch.

BatchScript_FMB_XML.zip

This has been a LIFESAVER for me in various projects. I have been able to use it to change font sizes and colours across hundreds of forms. I have even been able to put code in every form in my system in the when-new-form triggers.