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!

Oracle Forms 10g/11g (web version) Keyboard Shortcut Key List

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

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

 

Some times, you may forget about the shortcut key when working in oracle forms.

 To get the list at forms just press Ctrl + K, and you will get all the list.

Here i add in details.

Function	Shortcut Key
Show Shortcut Keys	Ctrl + K
Enter Query	F11
Execute Query	Ctrl + F11
Count Query	F12
Clear Block	F7
Clear Field	F5
Clear Form	F8
Clear Record	F6
Edit	Ctrl + E
Update Record	Ctrl + U
Insert Record	Ctrl + Down
Delete Record	Ctrl + Up
Commit	Ctrl + S
Duplicate Field	Shift + F5
Duplicate Record	Shift + F6
List of values	Ctrl + L
List Tab Pages	F2
Next Field	Tab
Next Record	Down Arrow Key
Next Primary	Key Shift + F7
Next Set of Records	Shift + F8
Previous Field	Shift + Tab
Previous Record	Up Arrow Key
Previous Block	Shift+PageUp
Scroll Down	PageDown
Scroll Up	PageUp
Up	Up Arrow Key
Down	Down Arrow Key
Print	Ctrl + P
Exit	F4
Help	Ctrl + H
Block Menu	Ctrl + B
Display Error	Shift + Ctrl + E

 Thanks for reading the post and congratulation on your success.

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.

 

Forms And Reports 6i Crash When Connection with 11g XE Database !!!

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

 Hope you are fine.. 

Not very useful for everybody but it's a solution if you need.

If you try to connect Oracle form & Reports 6i with Oracle Database 11g XE (Express Edition), every time, it will crash and you will not able to connect. 

But it will not happen with 11gR2 Enterprise or any other Edition.

>>?? Why this happen ?

Because, Database 11g XE use,

SQL> select * from v$nls_parameters where parameter like '%CHARACTERSET%';

PARAMETER                                                        VALUE                                                                                                                                                                                                                                                                                                                                                                                                                                             
---------------------------------------------------------------- ----------------------------------------------------------------                                                                                                                                                                                                                                                                                                                                                                                  
NLS_CHARACTERSET                                                 AL32UTF8                                                                                                                                                                                                                                                                                                                                                                                                                                          
NLS_NCHAR_CHARACTERSET                                           AL16UTF16                                                                                                                                                                                                                                                                                                                                                                                                                                         
 

you  need to set the database character set as UTF8.

To do so you need to follow the bellow steps..

1. connect as sysdba using SYSTEM not SYS.

Run the following command sequencially.

SQL>CONN SYSTEM/MANAGER AS SYSDBA

2. Shutdown the database if running:
SQL>SHUTDOWN IMMEDIATE

3. Start the database in restrict mode:
SQL>STARTUP RESTRICT

4. Change the databse charcter set to UTF8 as follows:
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;

5. Shutdown the database:
SQL>SHUTDOWN IMMEDIATE

6. At last, start the database in normal mode:
SQL>STARTUP

After successfull of these steps, you can connect to the Oracle XE database through Forms 6i or Oracle Reports 6i

 Comments to share your thoughts..


End for the day....

Praise to Almighty Allah(swt).  :)

Fi amanillah