Short note about development related stuff in OA Framework.
1. Find correct JDeveloper Patch for your application
1. Patch 4045639 - 9IJDEVELOPER WITH OA EXTENSION ARU FOR FWK.H
2. Patch 4141787 - 9IJDEVELOPER WITH OA EXTENSION ARU FOR CU1
3. Patch 4573517 - Oracle9i JDeveloper with OA Extension for 11.5.10 CU2
4. Patch 4725670 - 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP3
To determine which patch to use, you can simply check the framework
version in your instance by using http://host:port/OA_HTML/OAInfo.jsp,
then choose the matched one. If the version is 11.5.10K, please use
patch 4045639, 11.5.101CU, then use patch 4141787, 11.5.102CU, then
it should be patch 4573517, 11.5.103CU should be patch 4725670.
OA FWK Dev Guide
https://metalink.oracle.com/metalink/plsql/docs/269138.1.pdf
Search "JDeveloper" on this blog for more posts.
2. JDeveloper Debug Options
-Djbo.debugoutput=silent --> No Debug
-Djbo.debugoutput=console --> Debug to Console
.
3. Importing Certificates into JDev, needed if you are connecting to https URLs
C:\JDEV\jdevbin\jdk1.3.1\jre\bin\keytool -import -v -file ecustom.cer -keystore cacerts
Enter keystore password: changeit
Owner: CN=certification.owner.com
Issuer: CN=certification.owner.com
Serial number: blahblahblahblahblahblahblahblah
Valid from: Mon Oct 06 15:41:50 PDT 2008 until: Thu Oct 04 15:41:50 PDT 2018
Certificate fingerprints:
MD5: blahblah
SHA1: blahblah
Trust this certificate? [no]: yes
Certificate was added to keystore
.
4. Import OAF XML Page
java oracle.jrad.tools.xml.importer.XMLImporter OIEAPPROVERLOV.xml -jdk13 -mmddir "$OA_HTML/jrad" -rootdir . -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server.db.com)(PORT=9999))(CONNECT_DATA=(SID=SID)))"
.
5. OA Page Export
adjava -mx128m -nojit oracle.jrad.tools.xml.exporter.XMLExporter /oracle/apps/icx/icatalog/shopping/webui/NonCatalogRequestPG -username apps -password apps -dbconnection "(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=db.server.com)(PORT=9999)) (CONNECT_DATA=(SID=SID))) " -rootdir .
.
6. OA Page Personalization Export
adjava -mx128m -nojit oracle.jrad.tools.xml.exporter.XMLExporter /oracle/apps/icx/icatalog/shopping/webui/customizations/site/0/NonCatalogRequestPG -username apps -password apps -dbconnection "(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=db.server.com)(PORT=9999)) (CONNECT_DATA=(SID=SID))) " -rootdir .
.
7. List Customizations for OA Page
begin
jdr_utils.listDocuments('1.xml');
jdr_utils.LISTCUSTOMIZATIONS('/oracle/apps/icx/icatalog/shopping/webui/ShoppingHomePG');
end;
.
8. OA Page Personalization Import
adjava -mx128m -nojit oracle.jrad.tools.xml.importer.XMLImporter ./oracle/apps/ap/oie/entry/lines/webui/customizations/site/0/DetailsPG.xml -username apps -password apps -dbconnection "(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=db.server.com)(PORT=9999)) (CONNECT_DATA=(SID=SID))) " -rootdir .
.
9. OA Page Debug (Location for SOPLs (System.out.println Statements))
Location
$ORACLE_HOME/../9iAS/Apache/Jserv/logs/jvm
Check OACoreGroup.n.stdout [n can be 0,1,2,3 etc]
Check OACoreGroup.n.stderr [n can be 0,1,2,3 etc]
.
10. Stop/Start Apache Port
1.
cd $COMMON_TOP/admin/scripts
2.
./adapcctl.sh stop
3. Check if http processes still running, if running kill those, then proceed for start
ps -aef | grep -i http | grep -i DBNAME
4.
./adapcctl.sh start
.
11. Find Java file versions
cd $JAVA_TOP/oracle/apps/icx
1st Way
Execute the following at the unix prompt - from this directory -
for FILE in `find . -name '*.class' -print`
do
echo $FILE
strings -a $FILE | grep -i header: | cut -c1-78
done > $HOME/javaver.txt
2nd Way (assuming only one type of files)
XML Versions
find . -exec grep -i 'Header' {} \; -print > $HOME/xmlver.txt
.
