Oracle World: Jul 5, 2011

Tuesday, July 5, 2011

How to enable high tracing level for JRE and View The Java Console And Enable Tracing For Sun JRE (Native Plug-in)

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

How to enable high tracing level for JRE and View The Java Console And
Enable Tracing For Sun JRE (Native Plug-in)

HOW TO ENABLE /VIEW JAVA CONSOLE

In Windows:

Method :1

Open the Java control panel
Start --> Control Panel --> JAVA
Go to Advanced Tab--> Settings window--> Java Console and select 'Show Console' as shown in the Figure :1

Note:
Changes made through the Control Panel while a Plug-in is running will have no effect until restart

Method :2

From the Windows Task bar, right-click the Java coffee-cup icon labeled Java™ Platform, Standard Edition, and click on ‘Open Console’ to launch the Java Console as shown in Figure :2

Method :3

In IE /Mozilla Firefox

Go to Tools menu and select 'Sun Java Console'

In Netscape

Go to Tools --> Web Deployment and select 'Sun Java Console'

HOW TO ENABLE TRACING IN SUN JRE (NATIVE PLUGIN)

There are five levels of tracing available as follows:-

0 off
1 basic
2 network and basic
3 security, network and basic
4 extension, security, network and basic
5 LiveConnect, extension, security, network and basic

Method :1

Open the Java control panel
Start --> Control Panel --> JAVA
Go to Advanced Tab--> Settings window--> Debugging and select 'Enable tracing' as shown in the Figure :3

Note:
- By default, tracing in the JRE 1.5.0 Java Control Panel is turned off
- Changes made through the Control Panel while a Plug-in is running will have no effect until restart
- Tracing set through the Control Panel will take effect when the Plug-in is launched
- Tracing will get enabled for everthing (option 5 above)

Method :2

Open the Java control panel
Start --> Control Panel --> JAVA
Go to Java Tab and click on View Button in Subpanel : Java Runtime Settings
In the 'Java Runtime Parameters' column enter following values

Method :3

The trace level can be enabled by highlighting the java console window when it comes up and entering the appropriate number key for the tracing level required

Note:
- By default, tracing in the JRE 1.5.0 Java Control Panel is turned off
- This will enable tracing on the fly and based on the trace option number entered

HOW TO ENABLE LOGGING IN SUN JRE (NATIVE PLUGIN)

Similar to tracing, logging is a facility to redirect any output in the Java Console to a log file. Logging can be enabled by

Method :1

Open the Java control panel
Start --> Control Panel --> JAVA
Go to Advanced Tab--> Settings window--> Debugging and select 'Enable logging' as shown in the Figure :5

Note:
- By default, logging in the JRE 1.5.0 Java Control Panel is turned off
- Changes made through the Control Panel while a Plug-in is running will have no effect until restart
- Logging set through the Control Panel will take effect when the Plug-in is launched
- Log file (plugin<version>.log) will be created in the directory of the user by which one has logged in the
client pc
E.g: 'Documents and Settings\<user>\Application Data\Sun\Java\Deployment\log' directory.

Method :2

Open the Java control panel
Start --> Control Panel --> JAVA
Go to Java Tab and click on View Button in Subpanel : Java Runtime Settings
In the 'Java Runtime Parameters' column enter following values

-Djavaplugin.logging=true

Get Oracle Certifications for all Exams
Free Online Exams.com

FRM-92150 : Web Client Version Too New after migrating from Jinitiation to J2SE (j2se16013).

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

FRM-92150 : Web Client Version Too New after migrating from Jinitiation to J2SE (j2se16013). and upgraded the forms session from patchset 17 to 18

Symptoms:

1. 1st time start of the forms session no issue.
2. logout and relogin.
3. opens forms session getting FRM-92150

Log files:

Solution:

Use adadmin utility to :
- regenerate jar files - select YES when prompted to force generation of jar files.
- relink FND binaries
- recompile apps schema (recommended)
- regenerate FND forms and pll's

2. Clear Oracle jinitiator cache on client machine - typically c:\programs\oracle\jinit...\jcache .
3. Clear browser cache.
4. Bounce Oracle application services.
5. Re-test the issue.

If the above does not work, go for the below:

1. relink f60webmx executable and retest. If the issue still exists please go to step 2.
adrelink.sh force=y link_debug=y "fnd f60webmx"

2. follow the Note 209810.1 How to Relink Oracle Applications 11i Programs After Upgrade or Patch of the UNIX Operating System to relink the Oracle8 (8.0.6) programs and relink the Oracle Applications 11i programs.

If the above does not work, go for the below:

Apply Developer 6i patch for patchset 19 :-
6194129
Additional Patches:-
7423534 -( This patch need to be applied first in Additional Patches)
8402746
6125732
6857221
7657973
7343387 (Interoperability Patch)

Please also review the Note 788151.1 After Applying Forms 6i Patchset : FRM-92150 : Web Client Version Too New.

References:

Note 788151.1 After Applying Forms 6i Patchset : FRM-92150 : Web Client Version Too New
Note 469329.1 After Applying Forms 6i Patchset : FRM-92150 : Web Client Version Too New
Note 148428.1 Cannot log into Oracle Applications Getting FRM-92150 WEB .

Get Oracle Certifications for all Exams
Free Online Exams.com

How to get Output Post Processor log file

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

How to get Output Post Processor log file:

a. Navigate to Concurrent Manager Administer -> Select the Output Post Processor.

b. Choose the "Processes" button. Select the process that was active during the time you are interested in.

c. Choose the "Manager Log" button.

Get Oracle Certifications for all Exams
Free Online Exams.com

XML publisher completing in Warning when data size is big. One or more post processing actions failed java.lang.OutOfMemoryError

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: XML publisher completing in Warning when data size is big. One or more post processing actions failed java.lang.OutOfMemoryError

XML Publisher Report completes in Warning when data size is big with generic message, one or more post processing actions failed. Consult the opp log for details.

Using 11.5.10.2 RUP 6 , XML Publisher Report completes in Warning when data size is big with generic message,one or more post processing actions failed.consult the opp log for details.

REP-0151: Duplicate argument specification for keyword 'REPORT'.

Symptoms:

Log files:

FILE NAME: FNDOPP80221.txt
--------------------------------------------------

[6/17/09 6:54:42 AM] [main] Starting GSF service with concurrent process id = 80221.
[6/17/09 6:54:42 AM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
[6/17/09 6:54:42 AM] [Thread-12] Service thread starting up.
[6/17/09 6:54:42 AM] [Thread-13] Service thread starting up.
[6/17/09 8:32:38 AM] [OPPServiceThread1] Post-processing request 6012285.
[6/17/09 8:32:39 AM] [80221:RT6012285] Executing post-processing actions for request 6012285.
[6/17/09 8:32:39 AM] [80221:RT6012285] Starting XML Publisher post-processing action.
[6/17/09 8:32:39 AM] [80221:RT6012285]
Template code: XXFINARXAGE
Template app: XXFIN
Language: en
Territory: US
Output type: PDF
[061709_083239910][][EXCEPTION] [DEBUG] ------- Preferences defined PreferenceStore -------
[061709_083239911][][EXCEPTION] [DEBUG] ------- Environment variables stored in EnvironmentStore -------
[061709_083239911][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.LOW]:[-1]
[061709_083239911][][EXCEPTION] [DEBUG] [SECURITY_GROUP_ID]:[0]
[061709_083239911][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_INTERVAL]:[60]
[061709_083239912][][EXCEPTION] [DEBUG] [NLS_CHARACTERSET]:[UTF8]
[061709_083239912][][EXCEPTION] [DEBUG] [RESP_APPL_ID]:[-1]
[061709_083239912][][EXCEPTION] [DEBUG] [NLS_LANGUAGE]:[AMERICAN]
[061709_083239912][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MIN]:[1]
[061709_083239912][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MAX]:[2]
[061709_083239912][][EXCEPTION] [DEBUG] [NLS_NUMERIC_CHARACTERS]:[.,]
[061709_083239912][][EXCEPTION] [DEBUG] [APPS_JDBC_URL]:[jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=jaorddu1.dpa.co.ae)(PORT=1541)))(CONNECT_DATA=(SID=PTYD)))]
[061709_083239912][][EXCEPTION] [DEBUG] [RESP_ID]:[-1]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_MAX_JDBC_CONNECTIONS]:[500]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_USABLE_CHECK]:[true]
[061709_083239913][][EXCEPTION] [DEBUG] [USER_ID]:[-1]
[061709_083239913][][EXCEPTION] [DEBUG] [NLS_TERRITORY]:[AMERICA]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_PLSQL_RESET]:[false]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_CONTEXT_CHECK]:[true]
[061709_083239913][][EXCEPTION] [DEBUG] [NLS_DATE_FORMAT]:[DD-MON-RR]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_SIZE]:[1]
[061709_083239914][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.HIGH]:[-1]
[061709_083239914][][EXCEPTION] [DEBUG] [NLS_SORT]:[BINARY]
[061709_083239914][][EXCEPTION] [DEBUG] [NLS_DATE_LANGUAGE]:[AMERICAN]
[061709_083239914][][EXCEPTION] [DEBUG] [LOGIN_ID]:[-1]
[061709_083239914][][EXCEPTION] [DEBUG] ------- Properties stored in Java System Properties -------
[061709_083239914][][EXCEPTION] [DEBUG] [APPLTMP]:[/u03/ptyd/ptydcomn/temp]
[061709_083239914][][EXCEPTION] [DEBUG] [java.runtime.name]:[Java(TM) 2 Runtime Environment, Standard Edition]
[061709_083239914][][EXCEPTION] [DEBUG] [sun.boot.library.path]:[/opt/java1.4/jre/lib/PA_RISC2.0]
[061709_083239915][][EXCEPTION] [DEBUG] [java.vm.version]:[1.4.2 1.4.2.09-050713-05:46-PA_RISC2.0 PA2.0 (aCC_AP)]
[061709_083239915][][EXCEPTION] [DEBUG] [OVERRIDE_DBC]:[true]
[061709_083239916][][EXCEPTION] [DEBUG] [dbcfile]:[/u03/ptyd/ptydappl/fnd/11.5.0/secure/PTYD_jaoradu1/jaorddu1_ptyd.dbc]
[061709_083239916][][EXCEPTION] [DEBUG] [java.vm.vendor]:[Hewlett-Packard Company]
[061709_083239916][][EXCEPTION] [DEBUG] [java.vendor.url]:[http://www.hp.com/go/Java]
[061709_083239916][][EXCEPTION] [DEBUG] [path.separator]:[:]
[061709_083239916][][EXCEPTION] [DEBUG] [APPLCSF]:[/u03/ptyd/ptydcomn/admin]
[061709_083239916][][EXCEPTION] [DEBUG] [java.vm.name]:[Java HotSpot(TM) Server VM]
[061709_083239916][][EXCEPTION] [DEBUG] [file.encoding.pkg]:[sun.io]
[061709_083239916][][EXCEPTION] [DEBUG] [sun.os.patch.level]:[unknown]
[061709_083239917][][EXCEPTION] [DEBUG] [user.dir]:[/u03/ptyd/ptydcomn/admin/log/PTYD_jaoradu1]
[061709_083239917][][EXCEPTION] [DEBUG] [java.vm.specification.name]:[Java Virtual Machine Specification]
[061709_083239917][][EXCEPTION] [DEBUG] [java.runtime.version]:[1.4.2.09-050713-03:34]
[061709_083239917][][EXCEPTION] [DEBUG] [java.awt.graphicsenv]:[sun.awt.X11GraphicsEnvironment]
[061709_083239917][][EXCEPTION] [DEBUG] [java.endorsed.dirs]:[/opt/java1.4/jre/lib/endorsed]
[061709_083239917][][EXCEPTION] [DEBUG] [os.arch]:[PA_RISC2.0]
[061709_083239917][][EXCEPTION] [DEBUG] [JTFDBCFILE]:[/u03/ptyd/ptydappl/fnd/11.5.0/secure/PTYD_jaoradu1/jaorddu1_ptyd.dbc]
[061709_083239917][][EXCEPTION] [DEBUG] [java.io.tmpdir]:[/var/tmp/]
[061709_083239918][][EXCEPTION] [DEBUG] [line.separator]:[
]
[061709_083239918][][EXCEPTION] [DEBUG] [java.vm.specification.vendor]:[Sun Microsystems Inc.]
[061709_083239918][][EXCEPTION] [DEBUG] [os.name]:[HP-UX]
[061709_083239918][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MIN]:[1]
[061709_083239918][][EXCEPTION] [DEBUG] [sun.java2d.fontpath]:[]
[061709_083239918][][EXCEPTION] [DEBUG] [cpid]:[80221]
[061709_083239918][][EXCEPTION] [DEBUG] [runtime]:[aCC_AP]
[061709_083239918][][EXCEPTION] [DEBUG] [java.library.path]:[/opt/java1.4/jre/lib/PA_RISC2.0:/opt/java1.4/jre/lib/PA_RISC2.0/server:/opt/java1.4/jre/../lib/PA_RISC2.0:/u03/ptyd/ptydora/iAS/lib:/u03/ptyd/ptydora/8.0.6/network/jre11/lib/PA_RISC/native_threads:/u03/ptyd/ptydappl/cz/11.5.0/bin::/u03/ptyd/ptydora/8.0.6/lib:/usr/lib:/usr/lib]
[061709_083239919][][EXCEPTION] [DEBUG] [java.specification.name]:[Java Platform API Specification]
[061709_083239919][][EXCEPTION] [DEBUG] [java.class.version]:[48.0]
[061709_083239919][][EXCEPTION] [DEBUG] [java.util.prefs.PreferencesFactory]:[java.util.prefs.FileSystemPreferencesFactory]
[061709_083239919][][EXCEPTION] [DEBUG] [os.version]:[B.11.23]
[061709_083239919][][EXCEPTION] [DEBUG] [LONG_RUNNING_JVM]:[true]
[061709_083239919][][EXCEPTION] [DEBUG] [user.home]:[/home/applptyd]
[061709_083239919][][EXCEPTION] [DEBUG] [user.timezone]:[GMT+04:00]
[061709_083239920][][EXCEPTION] [DEBUG] [java.awt.printerjob]:[sun.print.PSPrinterJob]
[061709_083239920][][EXCEPTION] [DEBUG] [file.encoding]:[8859_1]
[061709_083239920][][EXCEPTION] [DEBUG] [java.specification.version]:[1.4]
[061709_083239920][][EXCEPTION] [DEBUG] [CACHEMODE]:[DISTRIBUTED]
[061709_083239920][][EXCEPTION] [DEBUG] [user.name]:[applptyd]
[061709_083239920][][EXCEPTION] [DEBUG] [java.class.path]:[/opt/java1.4/lib/dt.jar:/opt/java1.4/lib/tools.jar:/opt/java1.4/jre/lib/rt.jar:/opt/java1.4/jre/lib/charsets.jar:/u03/ptyd/ptydcomn/java/appsborg2.zip:/u03/ptyd/ptydcomn/java/apps.zip:/u03/ptyd/ptydora/8.0.6/forms60/java:/u03/ptyd/ptydcomn/java]
[061709_083239920][][EXCEPTION] [DEBUG] [DBCFILE]:[/u03/ptyd/ptydappl/fnd/11.5.0/secure/PTYD_jaoradu1/jaorddu1_ptyd.dbc]
[061709_083239921][][EXCEPTION] [DEBUG] [java.vm.specification.version]:[1.0]
[061709_083239921][][EXCEPTION] [DEBUG] [java.home]:[/opt/java1.4/jre]
[061709_083239921][][EXCEPTION] [DEBUG] [sun.arch.data.model]:[32]
[061709_083239921][][EXCEPTION] [DEBUG] [user.language]:[en]
[061709_083239922][][EXCEPTION] [DEBUG] [java.specification.vendor]:[Sun Microsystems Inc.]
[061709_083239922][][EXCEPTION] [DEBUG] [java.vm.info]:[mixed mode]
[061709_083239922][][EXCEPTION] [DEBUG] [logfile]:[/u03/ptyd/ptydcomn/admin/log/PTYD_jaoradu1/FNDOPP80221.txt]
[061709_083239922][][EXCEPTION] [DEBUG] [java.version]:[1.4.2.09]
[061709_083239922][][EXCEPTION] [DEBUG] [java.ext.dirs]:[/opt/java1.4/jre/lib/ext]
[061709_083239922][][EXCEPTION] [DEBUG] [sun.boot.class.path]:[/opt/java1.4/jre/lib/rt.jar:/opt/java1.4/jre/lib/i18n.jar:/opt/java1.4/jre/lib/sunrsasign.jar:/opt/java1.4/jre/lib/jsse.jar:/opt/java1.4/jre/lib/jce.jar:/opt/java1.4/jre/lib/charsets.jar:/opt/java1.4/jre/classes]
[061709_083239922][][EXCEPTION] [DEBUG] [java.vendor]:[Hewlett-Packard Co.]
[061709_083239923][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MAX]:[2]
[061709_083239923][][EXCEPTION] [DEBUG] [file.separator]:[/]
[061709_083239923][][EXCEPTION] [DEBUG] [java.vendor.url.bug]:[http://www.hp.com/go/Java]
[061709_083239923][][EXCEPTION] [DEBUG] [sun.io.unicode.encoding]:[UnicodeBig]
[061709_083239923][][EXCEPTION] [DEBUG] [sun.cpu.endian]:[big]
[061709_083239923][][EXCEPTION] [DEBUG] [APPLOUT]:[out/PTYD_jaoradu1]
[061709_083239923][][EXCEPTION] [DEBUG] [sun.cpu.isalist]:[pa2.0 pa1.2 pa1.1 pa1.0]
[6/17/09 8:37:44 AM] [UNEXPECTED] [80221:RT6012285] java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1657)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: java.lang.OutOfMemoryError

[6/17/09 8:37:45 AM] [80221:RT6012285] Completed post-processing actions for request 6012285.
[6/17/09 10:47:54 AM] [OPPServiceThread1] Post-processing request 6012954.
[6/17/09 10:47:55 AM] [80221:RT6012954] Executing post-processing actions for request 6012954.
[6/17/09 10:47:55 AM] [80221:RT6012954] Starting XML Publisher post-processing action.
[6/17/09 10:47:55 AM] [80221:RT6012954]
Template code: XXFINPLXXNOFFEM
Template app: PN
Language: en
Territory: US
Output type: PDF
[6/17/09 10:48:04 AM] [80221:RT6012954] XML Publisher post-processing action complete.
[6/17/09 10:48:04 AM] [80221:RT6012954] Completed post-processing actions for request 6012954.
[6/17/09 1:52:58 PM] [OPPServiceThread1] Post-processing request 6043871.
[6/17/09 1:52:58 PM] [80221:RT6043871] Executing post-processing actions for request 6043871.
[6/17/09 1:52:58 PM] [80221:RT6043871] Starting XML Publisher post-processing action.
[6/17/09 1:52:58 PM] [80221:RT6043871]
Template code: XXFINARXAGE
Template app: XXFIN
Language: en
Territory: US
Output type: PDF
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
[6/17/09 1:54:54 PM] [UNEXPECTED] [80221:RT6043871] java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1657)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: java.lang.OutOfMemoryError

[6/17/09 1:54:54 PM] [80221:RT6043871] Completed post-processing actions for request 6043871.
[6/17/09 2:53:31 PM] [OPPServiceThread1] Post-processing request 6049888.
[6/17/09 3:04:15 PM] [OPPServiceThread0] Post-processing request 6050871.
[6/17/09 3:27:26 PM] [OPPServiceThread1] Post-processing request 6056871.
[6/17/09 3:27:26 PM] [80221:RT6056871] Executing post-processing actions for request 6056871.
[6/17/09 3:27:26 PM] [80221:RT6056871] Starting XML Publisher post-processing action.
[6/17/09 3:27:26 PM] [80221:RT6056871]
Template code: XXFINARXAGE
Template app: XXFIN
Language: en
Territory: US
Output type: PDF
[6/17/09 3:27:34 PM] [80221:RT6056871] XML Publisher post-processing action complete.
[6/17/09 3:27:34 PM] [80221:RT6056871] Completed post-processing actions for request 6056871.
[6/17/09 3:30:16 PM] [OPPServiceThread0] Post-processing request 6057871.
[6/17/09 3:36:09 PM] [OPPServiceThread0] Post-processing request 6056874.

Solution:

1. Determine what the heap size per OPP process is currently:
select DEVELOPER_PARAMETERS from FND_CP_SERVICES
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

2. The default should be: J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m

3. Increase the Heap Space per Process to 1024:

update FND_CP_SERVICES
set DEVELOPER_PARAMETERS ='J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

4. Increase the values for these profiles for at least 2 hours each:
Concurrent:OPP Process Timeout
Concurrent:OPP Response Timeout

5.Run cmclean.sql and bounce the concurrent managers

References:

Note 304099.1 Using J2SE Version 5.0 with Oracle E-Business Suite 11i
Note 401561.1 Using J2SE Version 6.0 with Oracle E-Business Suite 11i
Note 315477.1 Ext/Pub XML Report Publisher Fails With java.lang.OutOfMemoryError:This note could work for this since they are on BIP 5.6.1
Note 371303.1 Ext/Pub Xml Publisher Receives Out Of Memory Java Error After Running A Number Of Jobs:
Note 387190.1 Ext/Pub Output Post Processor Fails with java.lang.OutOfMemoryError for Large Reports:
Note 549990.1 Int/Pub Java.Lang.Out of memoryerror Java Heap Space When Running Large Bi Pub Reports:

Get Oracle Certifications for all Exams
Free Online Exams.com

Users cannot enter invoices and process any transaction

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: users cannot enter invoices and process any transaction

When we try to enter invoice,Able to select supplier and Site, Then when we press Tab cursor dosn't move ahead..
Liability account should default from Supplier master not appear in Liability account tab,Can not move further ahead.
Funny part is no error msg getting.

Symptoms:

The issue can be reproduced at will with the following steps:
1. When we try to enter invoice
2. Able to select supplier and Site
3. Then when we press Tab cursor dosn't move ahead..
4. Liability account should default from Supplier master not appear in Liability account tab
5. Can not move further ahead.
6. Funny part is no error msg getting.

Log files:

Solution:

Issue might be due to uncompelled packages.

However , if it is not,

Apply Patch 8579071 and Confirm the following file versions:
forms/US/APXINWKB.fmb 115.1057
You can use the commands like the following:
strings -a $XX_TOP/filename |grep '$Header'

References:

Get Oracle Certifications for all Exams
Free Online Exams.com

Script To Check What ATG/Workflow Related Patches Are Installed In EBusiness Suite

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Script To Check What ATG/Workflow Related Patches Are Installed In EBusiness Suite

REM HEADER

REM $Header: atg_supp_patches.sql v7.0 GGGRANT $

REM

REM MODIFICATION LOG:

REM

REM GGGRANT

REM

REM Consolidated script to obtain the list of ATG/WF Major Patches applied from OWF G to R12.0.4

REM Added the EBS Version and did some minor cleanup.

REM

REM Added 12.0.6 AU and ATG

REM Added 12.1.1 Maintenance Pack

REM

REM Added 11i.ATG_PF.H.RUP7

REM

REM Added Oracle Applications Technology Release Update Pack 2 for 12.1 (R12.ATG_PF.B.DELTA.2)

REM Added Oracle E-Business Suite 12.1.2 Release Update Pack (RUP2)

REM

REM Added 12.1.3 Delta & Rup: 8919491, 9239090.

REM

REM atg_supp_patches.sql

REM

REM This script was created to collect the required information

REM to determine the which important ATG patches have been applied.

REM

REM How to run it?

REM

REM sqlplus apps/<password>

REM

REM @atg_supp_patches.sql

REM

REM Parameter:

REM

REM Output file

REM

REM atg_wf_applied_patches.html

REM

REM Created: Oct 17, 2008

REM Last Updated: Dec 31st, 2009

REM

set arraysize 1

set heading off

set feedback off

set verify off

SET CONCAT ON

SET CONCAT .

set lines 120

set pages 9999

def outputfile = "atg_wf_applied_patches.html"

spool &&outputfile

alter session set NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';

prompt </FONT>

prompt <HTML>

prompt <HEAD>

prompt <TITLE>Applied ATG Patches</TITLE>

prompt <STYLE TYPE="text/css">

prompt

prompt </STYLE>

prompt </HEAD>

prompt <BODY>

REM

REM ******* Ebusiness Suite Version *******

REM

prompt <TABLE BORDER=1>

prompt <TR><TD COLSPAN=9 BGCOLOR=BLUE><font color=white face=arial>

prompt <B>Ebusiness Suite Version</B></TD></TR>

prompt <TR>

prompt <TD>RELEASE_NAME</TD>

select

'<TR><TD>'||RELEASE_NAME||'</TD></TR>'

from fnd_product_groups;

prompt </TABLE><P><P>

REM

REM ******* Applied ATG Patches *******

REM

prompt <TABLE BORDER=1>

prompt <TR><TD COLSPAN=12 BGCOLOR=BLUE><font color=white face=arial>

prompt <B>Applied ATG/WF Patches</B></TD></TR>

prompt <TR>

prompt <TD>BUG_NUMBER</TD>

prompt <TD>LAST_UPDATE_DATE</TD>

prompt <TD>PATCH</TD>

prompt <TD>ARU_RELEASE_NAME</TD>

select

'<TR><TD>'||BUG_NUMBER||'</TD>'||chr(10)||

'<TD>'||LAST_UPDATE_DATE||'</TD>'||chr(10)||

'<TD>'||decode(bug_number,2728236, 'OWF.G INCLUDED IN 11.5.9',

3031977, 'POST OWF.G ROLLUP 1 - 11.5.9.1',

3061871, 'POST OWF.G ROLLUP 2 - 11.5.9.2',

3124460, 'POST OWF.G ROLLUP 3 - 11.5.9.3',

3126422, '11.5.9 Oracle E-Business Suite Consolidated Update 1',

3171663, '11.5.9 Oracle E-Business Suite Consolidated Update 2',

3316333, 'POST OWF.G ROLLUP 4 - 11.5.9.4.1',

3314376, 'POST OWF.G ROLLUP 5 - 11.5.9.5',

3409889, 'POST OWF.G ROLLUP 5 Consolidated Fixes For OWF.G RUP 5', 3492743, 'POST OWF.G ROLLUP 6 - 11.5.9.6',

3868138, 'POST OWF.G ROLLUP 7 - 11.5.9.7',

3262919, 'FMWK.H',

3262159, 'FND.H INCLUDE OWF.H',

3258819, 'OWF.H INCLUDED IN 11.5.10',

3438354, '11i.ATG_PF.H INCLUDE OWF.H',

3140000, 'ORACLE APPLICATIONS RELEASE 11.5.10 MAINTENANCE PACK',

3240000, '11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 1',

3460000, '11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 2',

3480000, 'ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK',

4017300 , 'ATG_PF:11.5.10 Consolidated Update (CU1) for ATG Product Family',

4125550 , 'ATG_PF:11.5.10 Consolidated Update (CU2) for ATG Product Family',

5121512, 'AOL USER RESPONSIBILITY SECURITY FIXES VERSION 1',

6008417, 'AOL USER RESPONSIBILITY SECURITY FIXES 2b',

6047864, 'REHOST JOC FIXES (BASED ON JOC 10.1.2.2) FOR APPS 11i',

4334965, '11i.ATG_PF.H RUP3',

4676589, '11i.ATG_PF.H.RUP4',

5473858, '11i.ATG_PF.H.RUP5',

5903765, '11i.ATG_PF.H.RUP6',

6241631, '11i.ATG_PF.H.RUP7',

4440000, 'Oracle Applications Release 12 Maintenance Pack',

5082400, '12.0.1 Release Update Pack (RUP1)',

5484000, '12.0.2 Release Update Pack (RUP2)',

6141000, '12.0.3 Release Update Pack (RUP3)',

6435000, '12.0.4 RELEASE UPDATE PACK (RUP4)',

5907545, 'R12.ATG_PF.A.DELTA.1',

5917344, 'R12.ATG_PF.A.DELTA.2',

6077669, 'R12.ATG_PF.A.DELTA.3',

6272680, 'R12.ATG_PF.A.DELTA.4',

7237006, 'R12.ATG_PF.A.DELTA.6',

6728000, '12.0.6 RELEASE UPDATE PACK (RUP6)',

7303030, '12.1.1 Maintenance Pack',

7651091, 'Oracle Applications Technology Release Update Pack 2 for 12.1 (R12.ATG_PF.B.DELTA.2)',

7303033, 'Oracle E-Business Suite 12.1.2 Release Update Pack (RUP2)',

9239089, 'Oracle Applications DBA 12.1.3 Product Release Update Pack',

8919491, 'Oracle Applications Technology 12.1.3 Product Family Release Update Pack',

9239090, 'ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK',

bug_number)||'</TD>'||chr(10)||

'<TD>'||ARU_RELEASE_NAME||'</TD></TR>'

from AD_BUGS b

where b.BUG_NUMBER in ('2728236', '3031977','3061871','3124460','3126422','3171663','3316333','3314376','3409889', '3492743', '3262159', '3262919', '3868138', '3258819','3438354','3240000', '3460000', '3140000','3480000','4017300', '4125550', '6047864', '6008417','5121512', '4334965', '4676589', '5473858', '5903765', '6241631', '4440000','5082400','5484000','6141000','6435000',

'5907545','5917344','6077669','6272680','7237006','6728000','7303030', '7651091', '7303033', '9239089', '8919491', '9239090')

order by BUG_NUMBER,LAST_UPDATE_DATE,ARU_RELEASE_NAME;

prompt </TABLE><P><P>

spool off

set heading on

set feedback on

set verify on

exit

;

Get Oracle Certifications for all Exams
Free Online Exams.com

How to display Work flow configuration in e-business suite: Work flow, queue ,agents and subscription version and status

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

How to display Work flow configuration in e-business suite: Work flow, queue ,agents and subscription version and status

a. Go to $FND_TOP/sql
b. Start sqlplus connected as APPS schema user.
c. Run these commands:
spool wfver.txt
start wfver.sql
d. Check wfver.txt file generated.

Get Oracle Certifications for all Exams
Free Online Exams.com

How to enable FND debug messages

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

How to enable FND debug messages

To enable FND: Debug while reproducing the issue

Connected as System Administrator, modify the following system profiles:
FND: Debug Log Enabled Yes
FND: Debug Log Filename <empty>
FND: Debug Log Level STATEMENT
FND: Debug Log Mode Asynchronous with Cross-Tier Sequencing
FND: Debug Log Module % or fnd%

There is no need to stop and restart E-Business Suite.

All log information will be created in the table FND_LOG_MESSAGES. A typical query might be

SQL> select module||' '||message_text from fnd_log_messages
order by timestamp;

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-20001 Unable to call fnd_ldap_wrapper.update_user, unable to use sso

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

ORA-20001 Unable to call fnd_ldap_wrapper.update_user, unable to use sso

Symptoms:

1. Successfully applied SSO patch p6117031 as a part of post patch of RUP6.

2. While updating the users password from frontend got the following error.

Unable to call fnd_ldap_wrapper.update_user due to the following reason:
ORA-20001: Unable to call fnd_ldap_wrapper.create_user due to the following
reason:An unexpected error occurred. Please contact your System Administrator

while updating the password with FNDCPASS, it give errors OID is not registered.

3. Done the following deregister and register to SSO/OID

i. txkrun.pl -script=SetSSOReg \
-deregistersso=Yes \

--- successfully executed this script

ii. txkrun.pl -script=SetSSOReg \
-deregisteroid=Yes \

--- successfully executed this script

iii. txkrun.pl -script=SetSSOReg \
-registersso=Yes \

iv. txkrun.pl -script=SetSSOReg \
-registeroid=Yes \

-- This give as partner application already registered.

But SSO login is not working and also update/Create user give same error.

Link on the fly means to have profile ''Applications SSO Auto Link User' to Enabled in order to populate -at first login- USER_GUID column in FND_USER table as long as the user exists in OID and has an orclguid, regardless if you are using WNA or other 3rd party LDAP integration. You really need to have the user in OID and have a valid orclguid otherwise you won't be able to perform the authentication. At this moment the user is not in OID so the link on the fly is not working.

Log files:

Review the FND: Debug files while reproducing the issue by

Connected as System Administrator, modify the following system profiles:
FND: Debug Log Enabled Yes
FND: Debug Log Filename <empty>
FND: Debug Log Level STATEMENT
FND: Debug Log Mode Asynchronous with Cross-Tier Sequencing
FND: Debug Log Module % or fnd%

There is no need to stop and restart E-Business Suite.

All log information will be created in the table FND_LOG_MESSAGES. A typical query might be

SQL> select module||' '||message_text from fnd_log_messages
order by timestamp;

Solution:

1 Applications SSO type profile was set to SSWA instead of SSWA w/SSO so SSO login page was not working. Change it to SSWA w/SSO and we will get the SSO login page.

- However, after doing that the SSO authentication didn't work. This was because Link on the fly feature was disabled. We set 'Applications SSO Auto Link User' to Enabled, but still the same problem and the error came up when updating the password for the users.

2 Then the user did not exist in OID so the SSO authentication could not be performed.

follow chapter 'Migrating Data between Oracle E-Business Suite Release 11i and Oracle Internet Directory' from Note 261914.1 and then to set profile Applications SSO Auto Link User' to Enabled This way Link on the fly feature should take care of the user password and authentication.

3 removereference

4 txkrun.pl -script=SetSSOReg -provtmp=$FND_TOP/admin/template/ProvBiDiNoCreation.tmp

References:

Follow chapter 'Migrating Data between Oracle E-Business Suite Release 11i and Oracle Internet Directory' from Note 261914.1

Get Oracle Certifications for all Exams
Free Online Exams.com

Databases shows status is down “There has been a user-initiated shutdown”

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: databases shows status is down “There has been a user-initiated shutdown”

Symptoms:

After Upgrading EMGC to 10.2.0.5, some databases shows status is down with "There has been a user-initiated shutdown." while databases are really UP

Log files:

emagent_perl.trc:
-------------------------
maxRowCount.pl: Mon Jun 15 15:29:04 2009: ERROR: Max Count Value not set properly in file /u01/app/oracle/product/agent10g/sysman/config/esa/database.properties line no. 68

emdctl.trc
-----------------

2008-08-04 13:49:40,163 Thread-1 ERROR main: nmectla_agentctl: Error connecting to http://jctpdb01.dubaiworld.ae:3872/emd/main/. Returning status code 1
2

2008-12-02 07:02:48,343 Thread-1 ERROR http: 6: Unable to initialize ssl connection with server, aborting connection attempt

emoms.trc:
----------------
2009-06-14 16:46:41,588 [EMUI_16_46_41_/console/targets$ctxType=Hosts] ERROR target.TargetData getTargets.958 - ORA-20001: Error in get_metrics_summary: ORA-28112: failed to execute policy function
ORA-06512: at "SYSMAN.EMD_MNTR", line 9666
ORA-06512: at line 1

java.sql.SQLException: ORA-20001: Error in get_metrics_summary: ORA-28112: failed to execute policy function
ORA-06512: at "SYSMAN.EMD_MNTR", line 9666
ORA-06512: at line 1

2009-06-15 15:20:10,871 [EMUI_15_20_10_/console/database/instance/sitemap] ERROR svlt.PageHandler handleRequest.640 - java.lang.NullPointerException
java.lang.NullPointerException

2009-06-15 15:20:10,855 [EMUI_15_20_10_/console/database/instance/sitemap] ERROR perf.sitemap logp.251 - Failed to initialize object: ORA-28112: failed to execute policy function
ORA-06512: at "SYSMAN.EMD_DATABASE", line 1166
ORA-06512: at line 1

2009-06-15 15:00:17,967 [AJPRequestHandler-ApplicationServerThread-957] ERROR eml.OMSHandshake processFailure.843 - OMSHandshake failed.(AGENT URL = https://pebpbp02.dubaiworld.ae:3872/emd/main/)(ERROR = INTERNAL_ERROR)(CAUSE =java.sql.SQLException: ORA-28112: failed to execute policy function

2009-06-15 14:43:22,151 [EMUI_14_43_22_/console/database/instance/instanceActivity] ERROR perf.instAct logp.251 - oracle.sysman.emo.perf.metric.eng.MetricCollectorTimeoutException

emagent.trc
-------------------
2009-06-15 15:29:03,246 Thread-20 ERROR : (nmecmgr.c,3207):Memory 0x0 encountered, expect struct_id=11011

Solution:

Hitting a Bug 5890966 for DB versions 10.2.0.2 and 10.2.0.3, so we need to apply one-off patch for the DB and another one for the agent

-- To implement the solution, please execute the following steps::
1.Download the needed patch:
- There are patches for Bug 5890966 for DB versions 10.2.0.2 and 10.2.0.3.
- download the one-off Patch 5890966 or upgrade to 10.2.0.4 version for the
target database.
- download Patch 7012242 for the agent.
- Check if there are any errors while accessing the job activity tab in grid
control.
2.Stop the OMS
3.stop the agent
4 .Follow the instructions the in Readme and apply the patchs
5.Restart all EM components and monitor again the error.

References:

Get Oracle Certifications for all Exams
Free Online Exams.com

upgraded Jinitiator to j2se16013.exe,accessing forms it as prompt security/warn The application's digital signature cannot be verified

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: upgraded Jinitiator to j2se16013.exe,accessing forms it as prompt security/warn The application's digital signature cannot be verified

upgraded Jinitiator to j2se16013.exe,accessing forms it as prompt security/warn

Warning - Security
The application's digital signature cannot be verified.
Do you want to run the application?
Name: NonForms

Symptoms:

After migrated Jinitiator to J2se by following related links from note 290807.1, successfully implemented the same but getting the below alert when starting the forms sessions.

Application Digital Signature cannot be verified, do you want to run the application
RUN or CANCEL button

And after check box "Always trust content for this publisher." It does pop up again

Log files:

Solution:

1. Clear the browser and jintiator/java caches from one PC having the issue

2. Run adadmin to Regenerate the jar files, this time with Force option

2. As per Note 290807.1 - Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
the solution is well to check the box "Always trust content from this publisher" then this "Warning - Security" message will not appear again when accessing this environment from your desktop client.

References:

Note 290807.1 - Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i

Get Oracle Certifications for all Exams
Free Online Exams.com

The WebPage Cannot be found HTTP 400 error_log : mod_security: Access denied with code 405. Pattern match "!(GET|HEAD|POST)" at REQUEST_METHOD.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: HTTP 400 Bad Request

The WebPage Cannot be found HTTP 400

error_log : mod_security: Access denied with code 405. Pattern match "!(GET|HEAD|POST)" at REQUEST_METHOD. [uri ""] [unique_id TgiU3YKCZIcAAAEVCkI]

Symptoms:

After upgrading from 12.0.6 to 12.1.3

Problem may come from the SecFilterSelective setting

You want to access to erptest-temp which has a '-' - the '-' may be not be allowed

Security.conf file has the following configuration:

SecFilterSelective REQUEST_URI "!^/OA_HTML/oowa/aw92/" chain
SecFilterSelective ARGS_NAMES "!^([-_|#!=A-Za-z0-9/ :,.$()]){0,255}([-_|#!=A-Za-z0-9/ :,.$()]){0,255}$"

SecFilterCheckUnicodeEncoding Off

After making a comparison between security.conf for the upgraded instance 12.1.3 and with the old instance 12.0.6, the below line differes :

12.1.3
SecFilterSelective ARGS_NAMES "!^([-_|#!=A-Za-z0-9/ :,.$()]){0,255}([-_|#!=A-Za-z0-9/ :,.$()]){0,255}$"

12.0.6
SecFilterSelective ARGS_NAMES "!^([-_@|#!=A-Za-z0-9/ \:\.\$]){0,255}$"

Log files:

Filename =error_log
See the following error:
[Mon Jun 27 12:12:12 2011] [error] [client 10.1.25.56] mod_security: Access denied with code 400. Error normalizing REQUEST_URI: Invalid URL encoding detected: invalid characters used [hostname "erptest-temp.auh.police"] [uri "/OA_HTML/jsp/fnd/fnderror.jsp?text=DE%20J*E%20*-HJD%20'DF8'E%20('DC'ED%20%DI%207H1%20'D5J'F).%201,'!%20'D'*5'D%20(E3&HD%20'DF8'E%20'D.'5%20(C"] [unique_id Tgg7XIKCZIcAAAETCDU]
[Mon Jun 27 12:25:02 2011] [error] [client 10.1.25.56] mod_security: Access denied with code 400. Error normalizing REQUEST_URI: Invalid URL encoding detected: invalid characters used [hostname "erptest-temp.auh.police"] [uri "/OA_HTML/jsp/fnd/fnderror.jsp?text=DE%20J*E%20*-HJD%20'DF8'E%20('DC'ED%20%DI%207H1%20'D5J'F).%201,'!%20'D'*5'D%20(E3&HD%20'DF8'E%20'D.'5%20(C"] [unique_id Tgg@XoKCZIcAAAEXCm4]
[Mon Jun 27 12:36:20 2011] [error] [client 10.1.25.56] mod_security: Access denied with code 400. Error normalizing REQUEST_URI: Invalid URL encoding detected: invalid characters used [hostname "erptest-temp.auh.police"] [uri "/OA_HTML/jsp/fnd/fnderror.jsp?text=DE%20J*E%20*-HJD%20'DF8'E%20('DC'ED%20%DI%207H1%20'D5J'F).%201,'!%20'D'*5'D%20(E3&HD%20'DF8'E%20'D.'5%20(C"] [unique_id TghBBIKCZIcAAAEXCnU]
[Mon Jun 27 12:36:30 2011] [error] [client 10.1.25.56] mod_security: Access denied with code 400. Error normalizing REQUEST_URI: Invalid URL encoding detected: invalid characters used [hostname "erptest-temp.auh.police"] [uri "/OA_HTML/jsp/fnd/fnderror.jsp?text=DE%20J*E%20*-HJD%20'DF8'E%20('DC'ED%20%DI%207H1%20'D5J'F).%201,'!%20'D'*5'D%20(E3&HD%20'DF8'E%20'D.'5%20(C"] [unique_id TghBDoKCZIcAAAETCEM]
[Mon Jun 27 14:29:35 2011] [error] [client 130.130.100.87] mod_security: Access denied with code 405. Pattern match "!(GET|HEAD|POST)" at REQUEST_METHOD. [uri ""] [unique_id Tghbj4KCZIcAAAEWCkY]
[Mon Jun 27 18:34:05 2011] [error] [client 130.130.100.64] mod_security: Access denied with code 405. Pattern match "!(GET|HEAD|POST)" at REQUEST_METHOD. [uri ""] [unique_id TgiU3YKCZIcAAAEVCkI]

Solution:

Clearing middle tier cache:

(R) Functional Administrator responsibility
(N) Core Services > Caching Framework > Global Configuration > Clear cache

Or manually delete all _pages caches and then regenerate all jsp as

rm -Rf $OA_HTML/_pages/*
rm -Rf $COMMON_TOP/_pages/*
rm -Rf $IAS_ORACLE_HOME/Apache/modplsql/cache/*

Unix: # $FND_TOP/patch/115/bin/perl ojspCompile.pl --compile --flush -p 2
Windows: C:> <FND_TOP>\patch\115\bin\perl -x ojspCompile.pl --compile --flush

FYI : Clearing the _pages in R12 creates a blank login page issue, as in Release 12 the jsp files do not get compiled automatically.
If you made it be accident, use the ojspcompile.pl perl script to perform a manual pre-compilation of the JSP pages. The following command will compile all the JSP pages and build up the JSP cache again.
Unix: # $FND_TOP/patch/115/bin/perl ojspCompile.pl --compile --flush -p 2
Windows: C:> <FND_TOP>\patch\115\bin\perl -x ojspCompile.pl --compile --flush

This utility is also used by the AD utilities to perform this action, for example after patches are applied which replaced 1 or more JSP pages. Since this a manual action which also requires understanding of parameters to be passed to have the right (set of) JSP compiled this option may be error-prone.

make a backup of the securitiy.conf file

change
SecFilterCheckUnicodeEncoding Off
to
SecFilterCheckUnicodeEncoding On

bounce the middle tier and try.

If not works, then try:

Clearing middle tier cache:

make a backup of the securitiy.conf file

change

SecFilterSelective ARGS_NAMES "!^([-_|#!=A-Za-z0-9/ :,.$()]){0,255}([-_|#!=A-Za-z0-9/:,.$()]){0,255}$"

to

SecFilterSelective ARGS_NAMES "!^([-_@|#!=A-Za-z0-9/ \:\.\$]){0,255}$"

bounce the middle tier and try.

If not works, then try:

3. try the below link:

http://<server>.<domain>:<PORT>/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE

if it gave you that the system still under maintenance mode, you should disable the maintenance mode using adadmin and try again

References:

Get Oracle Certifications for all Exams
Free Online Exams.com