Sunday 30 August 2015

EBS : FRM-92100

Error:

While java is loading FRM-92100 error is coming in all Forms.


Solution:

1. Take the backup of $CONTEXT_FILE
2. Change the context file parameter "s_forms_jvm_start_options", and add parameter:
-Doracle.net.disableOob=true
FROM:
<forms_jvm_start_options oa_var="s_forms_jvm_start_options">-server -verbose:gc -Xmx256M -Xms64M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB -XX:+UseParallelGC -XX:ParallelGCThreads=2 -Djava.security.policy=$ORACLE_HOME/j2ee/oacore/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -Doracle.security.jazn.config=/d01/UAT/inst/apps/UAT_erpapp02/ora/10.1.3/j2ee/forms/config/jazn.xml</forms_jvm_start_options>
TO:
<forms_jvm_start_options oa_var="s_forms_jvm_start_options">-server -verbose:gc -Xmx256M -Xms64M -XX:MaxPermSize=128M -XX:NewRatio=2 -XX:+PrintGCTimeStamps -XX:+UseTLAB -XX:+UseParallelGC -XX:ParallelGCThreads=2 -Djava.security.policy=$ORACLE_HOME/j2ee/oacore/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -Doracle.security.jazn.config=/d01/UAT/inst/apps/UAT_erpapp02/ora/10.1.3/j2ee/forms/config/jazn.xml -Doracle.net.disableOob=true</forms_jvm_start_options>
3. Run Autoconfig
4. Restart the application services

Reference : Intermittently Occurs FRM-92100 For All EBS Forms With "recv failed" Error Code (Doc ID 1908029.1)

Tuesday 25 August 2015

EBS : Login page alignment issue as Arabic login

Error:

When the login page is changed to arabic login, Some of the login areas are displayed nearly out of the browser window and USERNAME and PASSWORD fields are aligned on the left hand side vs centered.

Solution:

1) Log into the application as the "System administrator" responsibility
2) Choose Profile > System
3) Click in the USER field and add the username GUEST
4) Set the following profile options at user level

Personalize Self-Service Defn = No

5) Save the changes
6) Bounce the E-Business suite web tier services
7) Re-test the login issue

Reference : Main Login Page Layout Issue In BIDI Languages such as Arabic and Hebrew (Doc ID 453279.1)

Wednesday 12 August 2015

EBS : For specific users after login Null pointer exceptions

Error:

## Detail 0 ##
java.lang.NullPointerException
at java.util.Hashtable.put(Unknown Source)
at oracle.apps.fnd.common.DBPreferenceStore.load(DBPreferenceStore.java:162)
at oracle.apps.fnd.wf.worklist.webui.NtfWorklistCO.processRequest(NtfWorklistCO.java:185)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:604)


Solution:

CREATE TABLE FND_USER_PREFERENCES_BKP AS SELECT * FROM FND_USER_PREFERENCES;
UPDATE FND_USER_PREFERENCES SET PREFERENCE_VALUE='NtfSubject,' WHERE USER_NAME='&User_name' AND PREFERENCE_NAME='ADVANCED_WL_SORT_PREF';
COMMIT;

Reference: You have encountered an unexpected Error for Some Users Login. Stacktrace shows java.lang.NullPointerException related to NtfWorklistCO.class (Doc ID 1684285.1)

SQL Developer displaying Junk characters (??????)

Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...