Can Not Select an Expression for a Group By Performance Measure
Last updated on MAY 12, 2016
Applies to:Oracle Fusion Incentive Compensation Cloud Service - Version 184.108.40.206.0 and later
Oracle Fusion Incentive Compensation - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Then user create a new expression "2016 Payout Exp" and it is valid but can not select it to be assigned to the performance measure.
1. Create expression "2016 Payout Exp"
Navigator > Compensation Plans > Manage Expression
Expression = DECODE ( Measure result.Determine Pay Period_2016.ITD Output Achieved , 12 , Rate Table Rate * Measure.ITD Target , LEAST ( Rate Table Rate * Measure.ITD Target , 1.1 * Measure.ITD Target ) )
2. Create performance measure "2016 Incentive Payout"
Performance Interval = Annual
Process Transaction = Grouped by interval
Measure Formula expression's list of value (LOV) does not contain expression "2016 Payout Exp"
This was working before in the 2015 compensation plans.
Additional validation were introduced by Patch 19706444 which enforces if group by type of expression, then it requires an aggregate function.
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