'Add operation failed' Updating Data Filter on Custom Object (Doc ID 2098188.1)

Last updated on JANUARY 21, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), you cannot update a Data Filter on a custom table.  While, initially, you can add the update successfully and save it, when you re-open the data filter, the wrong table is listed in the definition.  Then, you get the following error when trying to update the Data Filter:

Add operation failed

The following error occurs in the FUSIONSUBSYSTEMSService.log in the OFSAA web server log directory:

[FUSIONSUBSYSTEMS] Dec 18,15 14:07:52 : [DATAELEMENTFILTERHANDLER]Exceeption while inserting data in rev_data filter table..java.lang.NumberFormatException: For input string: "null"
[FUSIONSUBSYSTEMS] Dec 18,15 14:07:52 : [DATAELEMENTFILTERHANDLER]
java.lang.NumberFormatException: For input string: "null"
    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:59)
    at java.lang.Integer.parseInt(Integer.java:460)
    at java.lang.Integer.parseInt(Integer.java:510)
    at com.ofs.reveleus.filters.mgmt.handlers.DataElementFilterHandler.insertDataElementFilterData(DataElementFilterHandler.java:383)
    at com.ofs.reveleus.filters.mgmt.handlers.DataElementFilterHandler.addFilter(DataElementFilterHandler.java:251)
    at com.ofs.reveleus.filters.mgmt.handlers.FilterHandler.handleAction(FilterHandler.java:175)
    at com.ofs.reveleus.filters.core.FiltersServlet.service(FiltersServlet.java:106)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)


and

[FUSIONSUBSYSTEMS] Dec 17,15 11:51:29 : [DATAELEMENTSERVICE]Error while getting column properties..java.lang.NullPointerException
[FUSIONSUBSYSTEMS] Dec 17,15 11:51:29 : [DATAELEMENTSERVICE]
java.lang.NullPointerException
    at com.ofs.reveleus.filters.util.DataElementService.getColumnProperties(DataElementService.java:322)
    at com.ofs.reveleus.filters.util.DataElementService.getDataElementFilterDisplayJSON(DataElementService.java:218)
    at com.ibm._jsp._dataElementFilter._jspService(_dataElementFilter.java:200)
    at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:99)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

The errors prevent you from updating the Data Filter.

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