Negative Values are not storing on the DFF Field created for a Page
(Doc ID 2387827.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Fusion Incentive Compensation Cloud Service - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
On : 184.108.40.206.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
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