Skip to main content

Compile Single JSP in Oracle ebs r12.1


1. Take a backup of .class file that will be modified due to jsp compilation -
$ cd $COMMON_TOP/_pages
$ ls -ltr _jtffmxrg.class
$ cp _jtffmxrg.class _jtffmxrg.class23dec2019

2. Check for last compilation time for .class file as follows -
$ cd $COMMON_TOP/_pages
$ ls -ltr _jtffmxrg.class

3. Your JSP file that will be compiled is stored under location -
$ cd $COMMON_TOP/webapps/oacore/html
$ ls -ltr jtffmxrg.jsp

Please note that above file will be used as reference to generate class(_jtffmxrg.class) file under - $COMMON_TOP/_pages

4.To compile JSP file, perl utility - ojspCompile.pl is located under -
$FND_TOP/patch/115/bin/
ojspCompile.pl uses "-s" option to compile single jsp.

$ cd $FND_TOP/patch/115/bin/
$ perl -x $JTF_TOP/admin/scripts/ojspCompile.pl --compile -s jtffmxrg.jsp



5. Check class file last modification date as follows -
$ cd $COMMON_TOP/_pages/
$ ls -ltr _jtffmxrg.class
-rw-r--r-- 1 applprod proddba 68390 Dec 23 09:13 _jtffmxrg.class

5. Restart application opmn services-
./adopmnctl.sh stopall
./adopmnctl.sh startall

6. Clear your web browser cache

Comments

Popular posts from this blog

Logfile locations in EBS r12.1 and EBS r12.2

Startup/shutdown Apps tier services are started and stopped frequently and we must know logfiles when troubleshooting startup/shutdown issues. $INST_TOP/logs/appl/admin/log $INST_TOP/logs/appl/admin/log Apache OHS being part of opmn in r12.1 has continued in r12.2. Logfile locations for troubleshooting have been changed $INST_TOP/logs/ora/10.1.3/Apache/error_log[timestamp] $INST_TOP/logs/ora/10.1.3/opmn/HTTP_Server~1.log $IAS_ORACLE_HOME/instances/*/diagnostics/logs/OHS/*/*log*   OPMN Logfile locations for r12.1 and r12.2 have been changed $INST_TOP/logs/ora/10.1.3/opmn/opmn* $IAS_ORACLE_HOME/instances/*/diagnostics/logs/OPMN/opmn/* Oacore oacore in r12.1 is oc4j component and part of 10gAS. However, in r12.2, oacore is now a managed server for weblogic server $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore*/ $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore*/ $LOG_HOME/ora/10.1.3/opmn/oacore*/oacor...
Defragment workflow related tables in r12   References- 1.     How to Reorganize Workflow Tables? (Doc ID 388672.1) 2.     EBS Workflow (WF) Analyzer (Doc ID 1369938.1) Points to Remember –     Some workflow tables are associated to queues so that it is necessary to use the advance queuing instructions to reorganize them. For tables other than queue tables, please refer to different notes created by RDBMS team to reorganize tables. This activity depends on the RDBMS version.       Defragment tables in workflow r12 Verify tables are not associated to queues – SQL> select queue_table from dba_queue_tables   2   where queue_table like '%WF%'; QUEUE_TABLE ------------------------------ WF_CONTROL WF_DEFERRED WF_DEFERRED_TABLE_M WF_ERROR WF_IN WF_INBOUND_TABLE WF_JAVA_DEFERRED WF_JAVA_ERROR WF_JMS_IN WF_JMS_JMS_OUT WF_JMS_OUT WF_NOTIFICATION_IN WF...

Query to Check AD and TXK code levels in your EBS environment

Below query can be very handy in finding out current AD and TXK code levels. col ABBREVIATION for a10 set lines 1000 col NAME for a50 col CODELEVEL for a20 SELECT ABBREVIATION,NAME,codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad'); ABBREVIATI NAME                                                CODELEVEL ---------- -------------------------------------------------- ------------ ad           Oracle Applications DBA                             C.11 txk         Oracle Applications Technology Stack    ...