Friday, November 16, 2012

Enable the next-generation Java Plug-in


In most cases it is best to deSelect the "Enable the next-generation Java Plug-in" check-box at the Java control panel -> Advaned Tab -> Java Plug-in -> Enable the next-generation Java Plug-in

You can do it automatically:

"C:\Program Files\Java\jre6\bin\ssvagent.exe" -high -jpisetup –old

or revert it back by:

"C:\Program Files\Java\jre6\bin\ssvagent.exe" -high -jpisetup –new







Tuesday, March 13, 2012

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)

Wednesday, February 29, 2012

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.



Thursday, February 23, 2012

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:



Monday, February 20, 2012

ShowJobs parameters for Oracle Reports


ShowJobs parameters for Oracle Reports

http://[serverName]/reports/rwservlet/showjobs?queuetype=past&count=100000&startrow=0&statusformat=xml


/reports/rwservlet/showjobs[n] - The refresh number n is optional. When it is specified, the report's queue status will be updated every n seconds.
[?]
[server=server_name]
[&authid=username/password]
[&queuetype={current|past|future}]
[&startrow=start_position_in_job_queue]
[&count=number_of_jobs_to_display]
[&statusformat={html|xml|xmldtd}]

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"