Negative Values are not storing on the DFF Field created for a Page
(Doc ID 2387827.1)
Last updated on APRIL 20, 2019
Applies to:
Oracle Fusion Incentive Compensation Cloud Service - Version 11.12.1.0.0 and laterInformation in this document applies to any platform.
Goal
On : 11.12.1.0.0 version, Classification
How to use the Between Operator for Staring Negative(-1) values?
Between operator is not fetching expected results
Based on a requirement to store negative number(Through a Custom DFF) in a custom number attribute for which 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, there exists a challenge with classification wherein it is supposed 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, 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
Solution
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
Goal |
Solution |
References |