Negative Values are not storing on the DFF Field created for a Page

(Doc ID 2387827.1)

Last updated on APRIL 26, 2018

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

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

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