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:

Goal

On : 11.12.1.0.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
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.