Unable To View Workflow Status Diagram

Refer Note ID 746806.1 


Applies to:

Oracle Workflow Cartridge – Version: 11.5.9 to 12.0.6
This problem can occur on any platform.


Symptoms
When clicked on the Status diagram following message appears “You have
encountered an unexpected error. Please contact the System Administrator
for assistance.”


The issue can be reproduced at will with the following steps:

   
1. Log in to Sysadmin
   
2. Select Workflow Adminstrator Responsbility
   
3. Select status monitor
    4. Provide the details of the item type
   
5. Click on status diagram. Now it shows error page.


Setting FND Diagnostics profile option for the user who is seeing the
error message is changing “You have encountered an unexpected error.
Click here for details. Please contact the System Administrator for
assistance.”


When pressed on the Click Here link the stack error trace shows:

oracle.apps.fnd.framework.OAException: java.lang.NullPointerException



## Detail 0 ##
java.lang.NullPointerException
java.lang.NullPointerException


or

## Detail 0 ##
java.lang.NullPointerException
at java.util.Hashtable.get(Hashtable.java:315)
at oracle.apps.fnd.util.OracleTimezone.getTimezoneNameFromCode(OracleTimezone.java:171)
at oracle.apps.fnd.framework.OANLSServices.getTimezoneName(OANLSServices.java:1611)
at oracle.apps.fnd.wf.monitor.webui.GraphMonitorCO.processRequest(GraphMonitorCO.java:107)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:525)



Cause:



Server Timezone profile option at Site level is not set.


The Null Pointer Exception is occurring from within OA Framework’s code which Workflow’s code is calling.

iAS need to instantiate the class file and if it finds the profile to
be null it throws a null pointer exception. The JSP is then cached once
the profile is set afterwords and we will just be reading the cached
class. The error started occurring after making EBS timezone aware so
the profile need to be set to the timezone of the database to provide
the off set calculation for user connections. 


Solution:



1. Set the profile option Server Timezone at Site level (should be set to the value of database timezone)
select DBTIMEZONE from dual;
2. Bounce the Apache Server

  • February 15, 2016 | 20 views