My Oracle Support Banner

Columns 'Commission_Payed_Itd' and 'Commission_Payed_Ptd' have 0 value after calculation. (Doc ID 314428.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 11.5.9 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.
Oracle Incentive Compensation - Version: 11.5.9 to 11.5.10This problem can occur on any platform.


1. Columns 'Commission_Payed_Itd' and 'Commission_Payed_Ptd' in table 'CN_SRP_PERIOD_QUOTAS_ALL' were not populated after calulation. They have values of 0.

2. Using the Group by Interval Formula Type. The Cumulative Flag is set to Yes.

3. These are the observations:

       Interval Type : Year
       Interval Numbers : Same for all periods.
       Formula : Group By

            In this case the Commission PTD and ITD fields are not populated.
            Only the Output Achieved   PTD and ITD fields are populated.

       Interval Type : Period
       Interval Numbers : Different for all the periods
       Formula : Group By

           In this case, only when we enter different   numbers for the periods, the
           Commission_Payed_Ptd and Itd fields are getting populated


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.