Negative Values are not storing on the DFF Field created for a Page
Last updated on APRIL 26, 2018
Applies to:Oracle Fusion Incentive Compensation Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 version, Classification
Between operator is not fetching expected results
We had a requirement to store negative number(Through a Custom DFF) in a custom number attribute for which we have created a custom character attribute due to system limitation. This attribute is used in an expression for getting sum(custom character attribute) which has been achieved by converting the character to number. Now, we are facing an issue with classification wherein we are suppose to put following criteria on a couple of custom character fields.
Condition 1 : Value < 100 (should consider -ve values as well)
Condition 2 : Value > 0
Condition 2 SEEMS to be achievable by putting a condition [is not like '-%']
For condition 1, we have tried the following and it doesn't work as expected.
1) is between 0 to 100 OR is like '-%'
**Is Between is also considering a value greater than 100
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