Open reports job - excel, delimeted ...

web.show_document(v_server_url || '/reports/rwservlet/getjobid' || v_jobid || '?server=' || :GLOBAL.rp2rroReportServer || '&mimetype=application/vnd.ms-excel', '_blank');

The application's digital signature cannot be verified

Walkaround:

1) Import the certificate into the user repository

• Accept the message on one PC 
• Copy "trusted.certs" (C:\Documents and Settings\\Application Data\Sun\Java\Deployment\security)  
• Paste in all profiles on the new PC's

Warning... will overwrite content that individuals may have added to their certificate repository. 

2) Import the certificate into the browser repository

• Accept the message on one PC  
• Launch the java control panel -> security tab -> certificates button
• Select the certificate & Export the certificate as .cer
• In the problematic PC Import the certificate into the browser repository:  Internet Explorer -> Tools -> Content -> Certificates -> Trusted Publishers -> Import. 

3) Sign jar files using a known 'trusted' certificate signing authority. 

See Note 1207184.1 Enhanced Signing of Oracle E-Business Suite JAR Files in Oracle Support





4) Change the order of the JAR files


A workaround is to change the order of the jar files listed in webutilArchive parameter in the formsweb.cfg file. Ensure jacob.jar is listed before frmwebutil.jar. (Please let me know if it worked)

Java has discovered application components that could indicate a security concern

Here is where I went wrong, maybe you can benefit:

I had an icon.jar file and I needed to add one more icon so I just went and used winrar without thinking.

What you need to do is to use the jar command to wrap up the file:

JAVA_HOME\bin\jar cvf icnFileName.jar *.gif


Don't forget to resign the file.

Tracing A Forms User

Tracing A Forms User 10g - quick and dirty

Let the user run the regular link + record=forms&tracegroup=0-199
ie:
http://machine:port/forms/frmservlet?config=myConfig&record=forms&tracegroup=0-199

You will get a trace file in the following location:

%ORACLE_HOME%\forms\trace\forms_xxx.trc where xxx is the forms session ID.


Open CMD window and do the following:

set ORACLE_HOME=[oracle home location]

set PATH=%ORACLE_HOME%\jdk\bin;%PATH%

set CLASSPATH=%ORACLE_HOME%\jdbc\lib\classes12.zip;%ORACLE_HOME%\forms\java\frmxlate.jar

java oracle.forms.diagnostics.Xlate datafile=%ORACLE_HOME%\forms\trace\forms_xxx.trc outputfile=%ORACLE_HOME%\forms\trace\html_xxx.html outputclass=WriteOutHTMLoutputclass parameter:
WriteOutHTML = HTML output

WriteOut = XML output

you will get a file html_xxx.html in your %ORACLE_HOME%\forms\trace directory.

In grater details:

http://docs.oracle.com/cd/B25016_04/doc/dl/web/B14032_03/tracing.htm#i1012933

Separate the Java client instances

Those parameters will separate the Java client instances so that they will not depend on each other:

[PARAM NAME="separate_jvm" value="true"]

separate_jvm="true"

Get the new frmwebutil.jar after 10.1.2.3 patch

Find the patch instalation directory


open CMD and go to:
[patchDir]\Disk1\stage\Patches\oracle.developer.forms.builder\10.1.2.3.0\1\DataFiles

run:
[$ORACLE_HOME$]\jdk\bin\jar xf webutil2.2.jar frmwebutil.jar

rename frmwebutil.jar0 to frmwebutil.jar

backup:
[$ORACLE_HOME$]\forms\java\frmwebutil.jar

copy the new frmwebutil.jar from
[patchDir]\Disk1\stage\Patches\oracle.developer.forms.builder\10.1.2.3.0\1\DataFiles
to
[$ORACLE_HOME$]\forms\java\

in the CMD go to:
[$ORACLE_HOME$]\jdk\bin

make sure to take down the apps server (using the EM)

run:
[$ORACLE_HOME$]\forms\webutil\sign_webutil.bat [$ORACLE_HOME$]\forms\java\frmwebutil.jar

restart the app server

ClientDPI

ClientDPI

Specifies the dots per inch (DPI) and overrides the DPI setting returned by the JVM, allowing you to manage varying DPI settings per platform. For example, a form developed on the Win32 platform may not display properly on the UNIX platform due to varying DPI values. The clientDPI value can be any positive integer. Oracle recommends that you use an integer between 50 and 200.