Calculation Does Not Pick Up Descriptive Flexfield Value From Performance Measures
Last updated on JUNE 25, 2018
Applies to:Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.18.02.0 and later
Oracle Fusion Incentive Compensation - Version 22.214.171.124.0 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