REP-1060: Reports Builder database tables have not been installed.

 Greetings from Hamid Blog

Issue on: Oracle Forms 10g, 6i

After opening the report builder, when you try to open an existing reports, you will get bellow error message.

REP-1060: Report Builder database tables have not been installed.
ORA-00942: table or view does not exist.
Report Builder tables may not be installed in the database.

cause: Database access is chosen in Reports Builder Preferences

Solution:

1) Open Reports Builder

2) Choose Tools -> Preferences

3) Go to Access tab and make sure that the checkbox next to 
   Access -> File
   is checked

4) Ensure that Access -> Database
   or
   Access -> File/database is not checked

Finally, you will get,

Thanks for reading my blog!

How to run Oracle Forms 10g with Java Web Start (Run Oracle Forms Application without Browser)

As salamualikum (islamic greetings), brothers and sisters. :)

  Hope you are well with the grace of Almighty Allah (swt).

 

If you want to start oracle application without web browser then without third party solution, you have option to run application with Java Web Start(javaws.exe)

For Oracle Forms Application version 10g(10.1.2.3), it’s about few little steps of configuration.

Follow the bellow steps to configure

1.       You need to install JRE first then Java web start will automatically be installed.

2.       Then create a JNLP file at <oracle_dev/app_home>\j2ee\home\default-web-app

give name webstart_10gl with the following code

<jnlp spec="1.0+" codebase="http://localhost:7778/forms/java/">

  <information>

    <title>Webstart Test Oracle Forms 10g</title>

    <vendor>hamid-oracle.blogspot.com</vendor>

    <homepage href="null"/>

    <description>Webstart Test Oracle Forms 10g</description>

  </information>

  <security>

    <all-permissions/>

  </security>

  <update check="timeout" policy="always"/>

  <resources>

    <java version="1.6.0"/>

    <jar href="frmall.jar" download="eager" main="true"/>

<!—If you have more jar file add it bellow, all see a list bellow -->

       <jar href="icons.jar" download="eager" main="true"/>

       <jar href="frmwebutil.jar" download="eager" main="true"/>

       <jar href="looks-2.0.1.jar" download="eager" main="true"/>

       <jar href="jcalendar-1.3.2.jar" download="eager" main="true"/>

       <jar href="FJCalendar.jar" download="eager" main="true"/>

       <jar href="jacob.jar" download="eager" main="true"/>

  </resources>

  <applet-desc name="Webstart Test Oracle Forms 10g" main-class="oracle.forms.engine.Main" width="990" height="668">

    <param name="background" value="no"/>

    <param name="logo" value="no"/>

    <param name="serverApp" value="default"/>

    <param name="lookAndFeel" value="oracle"/>

    <param name="allow_debug" value="true"/>

    <param name="separateFrame" value="false"/>

    <param name="em_mode" value="1"/>

    <param name="latencyCheck" value="true"/>

    <param name="networkRetries" value="240"/>

    <param name="serverArgs" value="module=LOGIN.fmx useSDI=yes"/>

    <param name="serverURL" value="http:// localhost:7778/forms/frmservlet?ifcfs=http:// localhost:7778/forms/frmservlet?config=ENVTX"/>

    <param name="colorScheme" value="teal"/>

    <param name="splashScreen" value="no"/>

    <param name="dontTruncateTabs" value="true"/>

  </applet-desc>

</jnlp>

3.      

Now create a shortcut of the file (webstart_10gl) in the desktop and make sure it’s General Tab “Open with Java(TM) Web Start Launcher” same as bellow image.

4.       Now double click the shortcut and play with application.

Please not, all of your jar file must signed by same Signature.

Thanks for reading the post and congratulation on your success.

 

How to Read Image / Picture in Oracle Reports from File System ?

As salamualikum (islamic greetings), brothers and sisters. :)

Hope you are well with the grace of Almighty Allah (swt).

Today, i discuss an important issue, many of oracle developer spend hours and hours to make a reports to show image from file system, which is much complex.

From Now on, it will be easy and remain easy. :)

Follow the bellow steps.

1. Take a Formula column
2. Data Type Char
3. Length 500
4. Set READ FROM FILE property to YES
5. Set File Format to Image
6. Make the Image stored folder as Shared Folder

Example Code::

function CF_IMAGEFormula return Char is
  
  filename VARCHAR2(200);
  tiff_image_dir VARCHAR2(80) :='<PC_NAME>/emp_picture/'; --// Folder name should be shared for shared link.
    out_file Text_IO.File_Type;
BEGIN

out_file :=Text_IO.Fopen(tiff_image_dir||:EMP_CODE||'.jpg', 'r'); -- r is read only AND EMP_CODE is the name of image.

filename := tiff_image_dir||:EMP_CODE||'.jpg';
return filename;

exception
when no_data_found then
RETURN tiff_image_dir||'blank.jpg';

when others then
if sqlcode=-302000 then
RETURN tiff_image_dir||'blank.jpg';
end if; 

end;


 You are Done :)
Pray for me to Almighty Allah (swt) to keep it up and for my hereafter.

Error FRM-92095: Oracle Jnitiator version too low

As salamualikum (islamic greetings), brothers and sisters,

Today my topic is Error FRM-92095: Oracle Jnitiator version too low

Symtom:

After logging into application, system pop up below error message:

FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2 or higher

Cause:

The JRE version is not incompatible.

Why it comes/shows ? 

When you have installed JRE version which is incompatible with your oracle form version, then you will get the above message. For example, your form version is 10.1.2.3 or 10.0.1.2 and your installed JRE version is 1.7.xx.xx, in that case you will get the message.

Cause this form version isn't certified by oracle corporation.

How to solve this ?

Open the "Java Control Panel" window.
Click the Java tab, then the View... button.

This should open a Java Runtime Environment Settings window with two tabs: User and System.
On User tab, under Runtime Parameters, enter:

-Djava.vendor="Sun Microsystems Inc."

OR

-Djava.vendor="New Oracle"

click Ok. then Apply and Ok.

 

That's it. Close the  brower and java console and retry.

Praise to Almighty Allah(swt).  :)

Fi amanillah