Calculation Does Not Pick Up Descriptive Flexfield Value From Performance Measures

(Doc ID 2414851.1)

Last updated on JUNE 25, 2018

Applies to:

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


Calculation based on performance measure descriptive flexfield expression is not generating correct commission.


1. Setup and Maintenance > Incentive Compensation Offerings > Configure Tables and Columns > Table : CN_SRP_PER_FORM_METRICS_ALL
    For column ATTRIBUTE7 , check the box for [ Calculation ] and set [User Name ] = Tipo Regola
2. Create an expression using this value
    TO_NUMBER ( DECODE ( NVL ( Tipo Regola , 'ALTRO' ) , 'IDTAGLIOINIZIATIVA' , 1 , 0 ) ) * Credit.Quantity
3. Use expression as input into rate table
4. Calculate Commission
5. Review calculation results and value is zero.



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