How to load all the java files required in an Oracle Applications 11.5.10.2 Instance

- Verify all the java files listed in the adldjava.drv under the location $AD_TOP/admin/driver

Usually for a 11.5.10.2 environment, the following jar files are present.

loadjava asf java/jar asfleadshare.jar

loadjava asg java/jar asgmtran.jar

loadjava csf java/jar csflf.jar

loadjava csf java/jar csflf.jar

loadjava cz java/jar czdb.jar

loadjava eam java/jar eampmsch.jar

loadjava eam java/jar eamwkbch.jar

loadjava ecx java/jar ecxutils.jar

loadjava fnd java/3rdparty/stdalone xmlparserv2.zip

loadjava fnd java/jar fndsec.jar

loadjava ibe java/jar ibeeos.jar

loadjava ieu java/jar ieutrans.jar

loadjava inv java/jar invdbtrx.jar

loadjava pay java/jar payproc.jar

loadjava pay java/jar payutil.jar

loadjava per java/jar perimage.jar

loadjava per java/jar perkpiclient.jar

loadjava wms java/jar wmscrtzn.jar

loadjava xtr java/jar xtrintrp.jar

- run adadmin and select the following options

- Generate JAR files

- Generate Applications Files menu

- Generate product JAR files

Answer "YES" when "Do you wish to force regeneration of all jar files? " is asked

- Reload those JAR files

- Under adadmin, select the following options

- Compile/Reload Applications Database Entities menu

- Reload JAR files to database

This will load the jar files listed in $AD_TOP/admin/driver/adldjava.drv

- Verify the loaded java objects using the query

select count(*) from dba_objects where owner = 'APPS' and object_type like '%JAVA%';

- Reload following jar files manually since they are not loaded by adadmin, according with the output of the $AD_TOP/admin/driver/adldjava.drv

cd $IAS_ORACLE_HOME

. ../.env

loadjava -user apps/apps -v -force -resolve $CSF_TOP/java/jar/csflf.jar

loadjava -user apps/apps -v -force -resolve $CZ_TOP/java/jar/czdb.jar

loadjava -user apps/apps -v -force –resolve $EAM_TOP/java/jar/eampmsch.jar

loadjava -user apps/apps -v -force -resolve $EAM_TOP/java/jar/eamwkbch.jar

loadjava -user apps/apps -v -force -resolve $ECX_TOP/java/jar/ecxutils.jar

loadjava -user apps/apps -v -force -resolve $ECX_TOP/java/jar/ecxprocess.jar

loadjava -user apps/apps -v -force -resolve $FND_TOP/java/3rdparty/stdalone/xmlparserv2.zip

loadjava -user apps/apps -v -force -resolve $FND_TOP/java/jar/fndcct.jar

loadjava -user apps/apps -v -force -resolve $INV_TOP/java/jar/invdbtrx.jar

loadjava -user apps/apps -v -force -resolve $INV_TOP/java/jar/invlabel.jar

loadjava -user apps/apps -v -force -resolve $ITG_TOP/java/jar/itgv1.jar

loadjava -user apps/apps -v -force -resolve $JTF_TOP/java/jar/jtfaoljdepen.zip

loadjava -user apps/apps -v -force -resolve $PER_TOP/java/jar/perimage.jar

loadjava -user apps/apps -v -force -resolve $PER_TOP/java/jar/perkigfclient.jar

loadjava -user apps/apps -v -force -resolve $PER_TOP/java/jar/perkpiclient.jar

loadjava -user apps/apps -v -force -resolve $WMS_TOP/java/jar/wmscrtzn.jar

loadjava -user apps/apps -v -force -resolve $XTR_TOP/java/jar/xtrintrp.jar

- Remove the classes comes with $PAY_TOP/java/jar/payproc.jar - These classes should not be in the database and they are not in the fresh database either :

dropjava -user apps/apps -verbose $PAY_TOP/java/jar/payproc.jar

- Run adadmin and select "compile APPS schema" option to validate all the invalid objects and verify if any invalid JAVA Objects left using sql below, there shouldn't be any.

select object_type, dbms_java.longname (object_name), status

from dba_objects

where owner = 'APPS'

and object_type like '%JAVA%' order by 1,2,3;