"Value(s) is not a valid number" Error when Specifying a String Value for Order String Flex Field Value Rate Basis Condition

(Doc ID 2329385.1)

Last updated on NOVEMBER 16, 2017

Applies to:

Oracle Transportation Management - Version 6.4.2 to 6.4.3 [Release 6.4]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
When attempting to add a string flex field value as a rate basis condition for a rate record and saving the rate cost, the following error is seen on the screen:

ERROR
---------------



EXPECTED BEHAVIOR
-----------------------
It is expected to be able to input a string value for the condition for any String Flex Field (i.e. Order String Flex Field Value) instead of having to input a number.

STEPS
-----------------------
The issue can be reproduced with the following steps:

1. Navigate to Contract and Rate Management -> Contract Management -> Rate Record
2. Search for and select to edit the respective rate record
3. Go to the 'Rate Costs' tab
4. Either edit an existing rate cost or add a new rate cost
5. Select a string flex field as a Basis Condition from the drop down menu (i.e. 'Order String Flex Field Value' )
6. Input an operator (i.e. =)
7. Input a string value (i.e. STRINGVALUE)
8. Click Save
9. The error is seen.

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