My Oracle Support Banner

Incorrect Classification Rule Being Selected with BETWEEN Operator (Doc ID 2817850.1)

Last updated on OCTOBER 28, 2021

Applies to:

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


The Classification process is not assigning the transaction to the expected rule.

The custom ATTRIBUTE_NUMBER2 has an EQUAL operator. User later enabled BETWEEN operator for this attribute.
The Classification Rule qualifying criteria changed to BETWEEN 0 and 99999.
The Deploy Classification Rules completed successfully.
However, Classify Credit did not classify to this rule.


1. Enable ATTRIBUTE_NUMBER2 on Base Transaction Descriptive Flexfield

       Setup and Maintenance > Manage Incentive Descriptive Flexfields
       Flexfield Code = CN_TP_BASETRANS_DFF
       Name = ICBU_AttrNum2
       Table Column = ATTRIBUTE_NUMBER2

2. Enable ATTRIBUTE_NUMBER2 for classification rule qualifier

       Setup and Maintenance > Manage Custom Rule Qualifiers
       Rule Type = Classification rules
       Qualifier Usage = Business Unit
       Business Unit = IC Business Unit
       Name = ICBU_AttrNum2
       Qualifier Operators = Equal to

3. Enable ATTRIBUTE_NUMBER2 to be used for Classification

       Setup and Maintenance > Configure Tables and Columns
       Column = ATTRIBUTE_NUMBER2
       User Name = Loan Net New Amount
       Classification = Checked

4. Create Classification Rule

     Compensation Plan > Manage Classification Rules
     Hierarchy= IC Business Classification Hierarchy
     Rule Name = Loan
          Qualifying Criteria:
          Name = ICBU_AttrNum2 , Equal to , 30

6. Run Deploy Classification Rules

7. Create Transaction with ATTRIBUTE_NUMBER2 = 30

8. Run Classify Credits and it classify correctly for this transaction

9.  Modify Rule Qualifier to enable BETWEEN operator for this attribute

     Setup and Maintenance > Manage Custom Rule Qualifiers
     Search: Business Unit=IC Business Unit,Name=ICBU_AttrNum2
     Edit : Qualifier Operators = Between , Not equal to

10.  Modify Classification Rules

       Compensation Plan > Manage Classification Rules
       Rule Name = Loan
       Qualifying Criteria : Name = ICBU_AttrNum2
       1) DELETE : Equal to , 30
       2) ADD : Between 0 and 9999999999

11. Run Deploy Classification Rules

12. Run Classify Credits and same transaction did not match this rule


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

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