Release 12.1.3 Applying Patch 20671106 - 'R12.FWK.B -- 18658202: BACKPORT: ERROR UNDER WORKLIST FORMS FAIL TO LAUNCH'

Release 12.1.3 Applying Patch 20671106 - 'R12.FWK.B -- 18658202: BACKPORT: ERROR UNDER WORKLIST FORMS FAIL TO LAUNCH'

Oracle Applications DBA version 12.2.3 or 12.2.4 Error Page On HomePage "Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance".

If facing above issue in Release 12.1.3, one of the patches to be applied is:

Patch 20671106 - 'R12.FWK.B -- 18658202: BACKPORT: ERROR UNDER WORKLIST FORMS FAIL TO LAUNCH'

Prerequisite Patches:

The following should be installed in the order shown before installing this patch.

1 R12.AD.B.delta.3 Oracle Applications DBA 12.1.3 Product Release Update Pack (Install on Oracle Applications DBA)

1 R12.ATG_PF.B.delta.3 Oracle Applications Technology 12.1.3 Product Family Release Update Pack (Install on Oracle Applications Technology Family)

2 R12.FWK.B.delta.4 R12.FWK.B.DELTA.4


- Source the Applications environment file
- Run the Patch Application Assistant by entering "admsi.pl".
- Apply the patch

This patch contains the following unified driver file to be applied with

AutoPatch:    u20671106.drv (This is the unified driver)

Release 12.1.3 Applying Patch 18936791 - 'R12.FWK.B.DELTA.4' Patch R12.FWK.B.delta.4: R12.FWK.B.DELTA.4

Release 12.1.3 Applying Patch 18936791 - 'R12.FWK.B.DELTA.4'  Patch R12.FWK.B.delta.4: R12.FWK.B.DELTA.4

Oracle Applications DBA version 12.2.3 or 12.2.4 Error Page On HomePage "Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance".

If the above issue persists on 12.1.3 instance, one of the patches to apply is

Patch 18936791 - 'R12.FWK.B.DELTA.4'  Patch R12.FWK.B.delta.4: R12.FWK.B.DELTA.4

Prerequisite Patches to be applied in below order:

1 R12.AD.B.delta.3 Oracle Applications DBA 12.1.3 Product Release Update Pack (Install on Oracle Applications DBA)

2 R12.ATG_PF.B.delta.3 Oracle Applications Technology 12.1.3 Product Family Release Update Pack (Install on Oracle Applications Technology Family)


- Apply the patch

This patch contains the following unified driver file to be applied with

AutoPatch:     u18936791.drv (This is the unified driver)

Release 12.2 Applying Patch 20132328 - 'R12.FWK.C - INTERMITTENT YOU HAVE ENCOUNTERED AN UNEXPECTED ERROR APPEARS IN E BUSINESS SUIT'

Applying Patch 20132328 - 'R12.FWK.C - INTERMITTENT YOU HAVE ENCOUNTERED AN UNEXPECTED ERROR APPEARS IN E BUSINESS SUIT'


Oracle Applications DBA version 12.2.3 or 12.2.4 Error Page On HomePage "Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance".

For Release 12.2, apply 

Patch 20132328 - 'R12.FWK.C - INTERMITTENT YOU HAVE ENCOUNTERED AN UNEXPECTED ERROR APPEARS IN E BUSINESS SUIT'


1.Source the Applications environment file

2.Run the Patch Application Assistant by entering "admsi.pl".

3. Pre-requisites:

The following should be installed in the order shown before installing this patch.

I) R12.AD.C.delta.3 ORACLE APPLICATIONS DBA 12.2.3 PRODUCT RELEASE UPDATE PACK (Install on Oracle Applications DBA)

I) R12.TXK.C.delta.5 R12.TXK.C.DELTA.5 (Install on Oracle Applications Technology Stack)

II) 12.2.3 ORACLE E-BUSINESS SUITE 12.2.3 RELEASE UPDATE PACK (Install on Oracle Applications Updates)

II) R12.AD.C.delta.5 AD R12.AD.C.DELTA.5 (Install on Oracle Applications DBA)

III) R12.ATG_PF.C.delta.4 R12.ATG_PF.C.delta.4 (Install on Oracle Applications Technology Family)

PLEASE NOTE: Some of the patches above may be superseded. Always check for latest patches before applying them.

4. For 12.2.X patches (using adop), you can perform the tasks in this section without shutting down the Application tier services.

Apply the patch with ADOP:

adop phase=apply patches=20132328

Oracle Applications DBA version 12.2.3 or 12.2.4 Error Page On HomePage "Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance".

Oracle Applications DBA version 12.2.3 or 12.2.4 Error Page On HomePage "Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance".

Error page shows below message

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: Connection has been administratively disabled by console/admin 

command. Try later. java.lang.Exception: It was disabled at <date-timestamp> at weblogic.jdbc.common.internal.ConnectionEnv.disable(ConnectionEnv.java:357) at 

weblogic.jdbc.wrapper.JDBCWrapperImpl.invocationExceptionHandler(JDBCWrapperImpl.java:127) at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:152) at 

oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:225) at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:201) at 

oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:176) at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:151) at 

oracle.apps.jtf.cache.GenericCacheLoader.load(Unknown Source) 


Also connections to Forms fail. 

However, EBS Technology Codelevel Checker (ETCC) shows patches are correctly applied and Autoconfig also completes with success.


Workarounds:

i) Refresh the page once logged in to enable navigation to continue normally.

Or


ii)Hide the Worklist Notifications table from Homepage.


Fix:

1) For Release 12.2, apply 


Patch 20132328 - 'R12.FWK.C - INTERMITTENT YOU HAVE ENCOUNTERED AN UNEXPECTED ERROR APPEARS IN E BUSINESS SUIT'

2) For Release 12.1.3, please apply following Patches :

I) Patch 18936791 - 'R12.FWK.B.DELTA.4'

Patch R12.FWK.B.delta.4: R12.FWK.B.DELTA.4


II) Patch 20671106 - 'R12.FWK.B -- 18658202: BACKPORT: ERROR UNDER WORKLIST FORMS FAIL TO LAUNCH'

If the issue still persists, check the JVM settings in the context file and set correct values.

Eg:

1. Change parameter in Context File on all nodes: 

FROM: 

<forms_jvm_start_options oa_var="s_forms_jvm_start_options">-Xms512m -Xmx512m -XX:CompileThreshold=8000 -XX:PermSize=128m -XX:MaxPermSize=256m 

<oacore_jvm_start_options oa_var="s_oacore_jvm_start_options">-Xms512m -Xmx512m -XX:CompileThreshold=8000 -XX:PermSize=128m -XX:MaxPermSize=256m 

<oafm_jvm_start_options oa_var="s_oafm_jvm_start_options">-Xms512m -Xmx512m -XX:CompileThreshold=8000 -XX:PermSize=128m -XX:MaxPermSize=256m 

TO: 

<forms_jvm_start_options oa_var="s_forms_jvm_start_options">-Xms512m -Xmx1024m -XX:CompileThreshold=8000 -XX:PermSize=128m -XX:MaxPermSize=256m 

<oacore_jvm_start_options oa_var="s_oacore_jvm_start_options">-Xms512m -Xmx1024m -XX:CompileThreshold=8000 -XX:PermSize=128m -XX:MaxPermSize=256m 

<oafm_jvm_start_options oa_var="s_oafm_jvm_start_options">-Xms512m -Xmx1024m -XX:CompileThreshold=8000 -XX:PermSize=128m -XX:MaxPermSize=256m 

2. Run autoconfig to deploy the parameter setting


Also see other related posts:

Oracle Applications Technology Stack 12.2.4 - Cannot open Oracle Forms: Java null pointer exception error with Java 6 Update 27 Java Plug-in on Client Machine

EBS 12.2.3 & 12.2.4 - oacore_server1.out growing large in size JBO DEBUG LOGGING ON WITHOUT -D FLAG, NOTICE LEVEL AND PROD MODE=TRUE