Make EBS R12 Compatible for Mac OS X v10.9.x with Safari Browser (as well as for Windows Client PC also)

We have requirement to open forms of our EBS R12 (12.1.3) Production Instance on Mac OS X v10.9 Client PC with their Safari Browser but it should be still compatible with Windows OS.

To implement this, we have followed below Metalink Note IDs,

• Recommended Browsers for Oracle E-Business Suite Release 12 (Doc ID 389422.1)

• Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1)

• Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)

• Using JDK 7.0 Latest Update with Oracle E-Business Suite Release 12.0 and 12.1 (Doc ID 1467892.1)

1) Issues Faced While Applying OPatch for 10g AS 10.1.2.3,

OPATCH_JAVA_ERROR=CHECKCONFLICT: OPATCH CANNOT PROCESS OVERLAY PATCHES BECAUSE OF NO OUI SUPPORT. PLEASE TAKE LATEST OUI 10.1 PATCHSET FROM "MY ORACLE SUPPORT" AND TRY AGAIN.

Solution: http://manishnashikkar.blogspot.in/2014/07/opatchjavaerrorcheckconflict-opatch.html

2) Issue faced while opening form in Windows :



Unsigned Entry in Resource Error

java.lang.SecurityException: com.sun.deploy.net.JARSigningException: Found unsigned entry in resource: http://server1.example.com:10403/OA_JAVA/oracle/apps/fnd/jar/fndforms.jar 

Workaround : 

If you are unable to upgrade your JDK at this time, you can workaround this issue by turning off Java caching through the Java Control Panel on the desktop:

Java Control Panel -> General (tab) -> Settings (button) -> Keep Temporary Files on the Computer (Uncheck)

Solution :

1. Upgrade the JDK version of your application tier node by following the appropriate document below: 

• Using Latest Java 6.0 Update With Oracle E-Business Suite Release 12 (Document 455492.1)

• Using JDK 7.0 Latest Update with Oracle E-Business Suite Release 12.0 and 12.1 (Document 1467892.1)

2. Regenerate the jar files using the 'force' option through adadmin.

Script to find Apache, Java, JRE, Forms version for Oracle E-Business Suite R12

The below script collects Apache, Java, Client JRE, Forms, Perl, PL/SQL versions and Forms communication mode. (Only for R12 and do not run on 11i Instance)

Before running the script ensure that you have sourced the environment file APPS<SID>_host.env from $APPL_TOP after logging into the system as applmgr user, otherwise the script will not run successfully


# +===========================================================================+
# | FILENAME
# | Instancedetails_R12.sh
# |
# | DESCRIPTION
# |   This script can be used to collect Apache, Jserv, Forms, Jinitiator and  
# |   Perl version in E-Business suite R12
# |
# | PLATFORM
# | Unix Generic, Linux, HP-UX,IBM AIX, Sunsolaris 
# |
# | NOTES
# |   Before running the script ensure that you have sourced the environment 
# |   by running APPS<SID>_host.env file from $APPL_TOP.  
# |
# | HISTORY
# |   Version 1.0
# +===========================================================================+
#
(
echo "Script Started "
date
## The script shows output on screen and creates file named hostname_date.txt file in current ## directory
## Collect the Apache version
echo "*****Apache Version*****"
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v
echo " "
## Collect perl version
echo "*****perl version******"
$IAS_ORACLE_HOME/perl/bin/perl -v|grep built
echo " "
## Collect Java version
echo "******Java Version******"
sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"
echo " "
## Collect client JRE version
echo "*****Client JRE version*****"
cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35
echo " "
## Collect Forms version
echo "*****Forms Version*****"
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
echo " "
## Collect PL/SQL Version
echo "*****PL/SQL Version****"
$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version
echo " "
## Collect Forms communication mode
echo "****Forms Communication Mode****"
cat $FORMS_WEB_CONFIG_FILE|grep serverURL=
echo "If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet"
echo " "
echo "Script Completed Successfully and it has generated the file  zz`hostname`_`date +%m%d%y.%H%M`.txt file in current directory"
echo "Script completed "
date
) 2>&1 | tee zz`hostname`_`date +%m%d%y.%H%M`.txt
###
### END OF SCRIPT
###


=================== Output =========================

[applmgr@ebs1 ~]$ . /u01/app/oracle/EBS/apps/apps_st/appl/APPSEBS_ebs1.env

[applmgr@ebs1 ~]$ sh InstanceDetails.sh
Script Started
Thu Jan 19 22:30:14 IST 2012
*****Apache Version*****
Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server
Server built:   Jul  7 2008 14:58:00

*****perl version******
This is perl, v5.8.3 built for i686-linux-thread-multi

******Java Version******
java version "1.6.0_10"
Java(TM) SE Runtime Environment (build 1.6.0_10-b33)
Java HotSpot(TM) Client VM (build 11.0-b15, mixed mode)

*****Client JRE version*****
sun_plugin_version=1.6.0_07

*****Forms Version*****
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

*****PL/SQL Version****
PL/SQL Version 10.1.0.5.0 (Production)

****Forms Communication Mode****
serverURL=/forms/lservlet
If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet

Script Completed Successfully and it has generated the file  zzebs1.oracle.com_011912.2230.txt file in current directory
Script completed
Thu Jan 19 22:30:15 IST 2012
 


Cheers !!!