My Oracle Support Banner

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:

Oracle Trade Management - Version 12.2.10 and later
Information in this document applies to any platform.


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(
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(
at oracle.jbo.server.ViewRowSetImpl.execute(
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(
at oracle.jbo.server.ViewRowSetImpl.executeQuery(
at oracle.jbo.server.ViewObjectImpl.executeQuery(
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(
at oracle.apps.fnd.framework.server.OAViewObjectImpl.initQuery(
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.setCriteriaOnVO(
at oracle.apps.fnd.framework.webui.OAQueryHelper.handleCustomizeGoButtonAfterController(


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.



To view full details, sign in with your My Oracle Support account.

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

In this Document

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