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 laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |