In Buyers Work Center (BWC) View Results - 'You have encountered a system error' (Doc ID 2276483.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version,

Procurement: Problem using saved views as default

Customer is experiencing a system error when attempting to set a new default view from "view orders" screen

and using  Period Start Date as one of the search criteria.

This returned the generic error message.


ERROR
-----------------------
"You have encountered a system error. Contact your system administrator for assistance."


## Detail 0 ##
java.lang.NullPointerException
at oracle.sql.Datum.getBytes(Datum.java:166)
at oracle.sql.DATE.timestampValue(DATE.java:803)
at
oracle.apps.fnd.framework.OANLSServices.dateToCanonical(OANLSServices.java:2288)
at
oracle.apps.fnd.framework.customjrad.webui.CustomJRADTableViewsUpdateCO.insertCriteria(CustomJRADTableViewsUpdateCO.java:4187)
at
oracle.apps.fnd.framework.customjrad.webui.CustomJRADTableViewsUpdateCO.processFormRequest(CustomJRADTableViewsUpdateCO.java:3139)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:827)
at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at
oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1039)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1005)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:860)
at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at
oracle.apps.fnd.framework.webui.be


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in using Purchasing responsibility
2. Navigate to Buyer Work Center ( BWC ), orders tab and then distributions subtab.
3. Add the Accounting Period Start and Accounting Period End to the
    search criteria, click on "save search"
4. Give a view name "PO Track 17" and apply, it works well.
5. Choose View "PO Track 17" and click "Personalize" button, then click "Update".
  Do not change anything but click "Apply" and get  error.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms