Error While Performing Claims Saved Search In Trade Management: The value xxxxx specified for the item custacctldfv is an invalid number (Doc ID 2941936.1)

Last updated on APRIL 12, 2023

Applies to:

Symptoms

After modifying a Saved Search for claims, Trade Management user gets the following an error while performing the search:

oracle.apps.fnd.framework.oaexception the value DD-MON-YYYY specified for the item custacctldfv is an invalid number

From logs the following error stack is shown:

UNEXPECTED:[fnd.framework.webui.OAQueryHelper]:oracle.apps.fnd.framework.OAException: Application: FND, Message Name: INVALID_NUMBER_JAVA_TYPE. Tokens: VALUE = 10-Mar-2023; ITEMNAME = custAcctIdFv;
at oracle.apps.fnd.framework.server.OAViewObjectImpl.setWhereClauseFromCriteria(OAViewObjectImpl.java:2146)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:5088)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:900)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:814)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:808)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:470)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.initQuery(OAViewObjectImpl.java:803)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.setCriteriaOnVO(OAWebBeanHelper.java:2482)
at oracle.apps.fnd.framework.webui.OAQueryHelper.handleCustomizeGoButtonAfterController(OAQueryHelper.java:5815)

Steps to reproduce:

1. Login with Responsibility: Oracle Trade Management User

2. Navigation: Channel Revenue Management -> Claims

3. Click on PERSONALIZE button to see all the saved searches

4. Modify a saved search by clicking on the pencil under 'Update'.

5. Modify search criteria to something similar to the following:

Search Criteria:  Match: All

Customer is XXXX
Claim Type is New Store Discounts
Claim Status is Closed
GL Date after 01-May-2019
GL Date before 10-Mar-2023

6. Save/Apply and try to execute the search.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.