My Oracle Support Banner

Performance Measure With Expression Using Weight Resulted In Zero Commission Amount (Doc ID 2533695.1)

Last updated on NOVEMBER 21, 2019

Applies to:

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

Symptoms

Commission calculated is $0 ( zero ) when the expression uses MAX( Performance Measure.Weight ) .  If the expression does not reference Weight then it calculated as expected.

STEPS TO REPRODUCE
1. Enable Tables and Columns : Enable for Calculation for CN_SRP_PLAN_COMPONENTS_ALL .TARGET_INCENTIVE_WEIGHT  , User Name =  TI Weight


2. Create Compensation Plan :
    a. Travel Compensation Plan , Target Incentive = 25,000
    b. Create Performance Measures :
        1) Hotel Individual PM1, credit category = HOTEL, Weight 40
            Measure Formula =Credit.Credit Amount
         2) Resort GroupBy PM2 , credit category = RESORT, Weight 30
             Measure Formula = SUM ( Credit.Credit Amount )
    c. Create Plan Component :
         1) Hotel PerInterval PC1 , Target Incentive Percent = 70 , Calculation Sequence = 1
             Incentive Formula = Measure result.Hotel Individual PM1.Output Achieved * Measure result.Hotel Individual PM1.TI Weight
             Attached performance measure : Hotel Individual PM1
         2) Resort PerEvent PC2 , Target Incentive Percent = 60 , Calculation Sequence = 2
             Incentive Formula = Measure result.Resort GroupBy PM2.ITD Output Achieved * Measure result.Resort GroupBy PM2.TI Weight
             Attached performance measure : Resort GroupBy PM2

3. Assign Participant to Comp Plan

4. Create Transactions :
    Transaction Number Amount Attribute
                      Trx1 1000 HOTEL
                      Trx2 1000 RESORT
                      Trx3 1000 RESORT

5. Run All Transaction Processes

6. Review Earnings

    Calculation Details :
        Hotel Individual PM1.Output Achieved = 1000 -- correct
        Hotel PerInterval PC1 = 1000 x 0.40 = 400 -- correct

   Calculation Details :
       Resort GroupBy PM2.ITD Output Achieved = 2000 -- correct
       Resort PerEvent PC2 = 2000 x 0 ?? .... measure weight should be 0.30

Cause

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
Symptoms
Cause
Solution
References


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