DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, February 15, 2016

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

1 comment:

Sridevi K said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.