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

How to Make Drill Down (Hyperlink) Report in Oracle Reports 10g/11g?

Greetings in Islamic way “As salamualikum”

Hyperlink reports in oracle means call another report from a report by clicking at a value.  For example, we have a report like bellow,

ID	Name
10001	Abdul Hamid
10002	Hamidur Rahman Siddique

And we want to call another report named DETAIL_INFO of a person by clicking on ID. How can we achieve this?

My example also helps to Hiding username/password when calling a report from another report

Follow the bellow steps and you are done.

1.       First stop the report server. (OC4J instance also for 10g)

2.       Search for CGICMD.DAT file in Developersuite home. (for 10g It’s located at <DevSuiteHome_1\reports\conf> folder. And for 11g D:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.1.2\configuration)

3.       Open the CGICMD.DAT file and go to bottom line and add the bellow lines and modify as your value.

 ; ** MY DEFINE ** BY ** HAMIDHELAL **

hrs: userid=test/password@orcl server=rep_server desformat=pdf destype=cache paramform=no %*

(Where first userid, report server name, report destination format, destination type and no parameter form.)

4.       Save and close the file.

5.       Now open the report which will have the link.

6.       Select the data field and press F11 to go code editor and add the bellow code before

return (true);

SRW.SET_HYPERLINK('http://SERVER_NAME:8889/reports/rwservlet?hrs+report='D:\ID_CARD_ALL.rep+EMPID='||:EMP_ID);

(Change the report server url as you have, report name and parameter if you have)

Compile and save the reports. If needs convert to any other extension.

Now Run the report server and run your report…

You are done :)

 

Hope this helps…

How to Get Number of Days In a Year ?

If you cannot calculate how many days in a year, here is an easy example for you. Write down the bellow code directly in sql*plus or SQL Developer or any others tools and get the result. :)

SELECT ADD_MONTHS(TRUNC(SYSDATE,'RRRR'),12)-TRUNC(SYSDATE,'RRRR')
FROM DUAL;

Hope it helps...

If any query, just leave your comments...