OAF [OA Framework Development] Related Stuff

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

.