Unable To View Status Diagram [ID 746806.1]

Unable To View Status Diagram [ID 746806.1]

--------------------------------------------------------------------------------

Modified 29-DEC-2008 Type PROBLEM Status MODERATED

In this Document
Symptoms
Cause
Solution
References



--------------------------------------------------------------------------------


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.



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)
2. Bounce the Apache Server

FROM: http://appsdbastuff.blogspot.com/2010/05/unable-to-view-status-diagram-id.html