My Oracle Support Banner

Cannot Use An Expression In Group By Formula (Doc ID 1454823.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


You are creating a formula that will calculate once a period with the commission based on sales target attainment.

You tried using :

      SUM(Commission Headers.TRANSACTION_AMOUNT)/SRP Period Quota.TARGET_AMOUNT

as the input expression but it is not usable with group by functions.


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.