Incentive Compensation Attinament and Earnings Subject Area Missing SRP_COMP_PLAN_ID to Differentiate the Compensation Plan Assignment (Doc ID 2773646.1)

Last updated on MAY 03, 2021

Applies to:

Symptoms

The participant is assigned to the same compensation plan twice but with two different date range.
The report based on subject areas "Incentive Compensation - Participant Compensation Plan Real Time" has "Participant Plan Component Details"."Compensation Plan ID" which is the SRP_COMP_PLAN_ID field. This reflected the correct quota amounts.
However, when join the analysis to subject area "Incentive Compensation - Earning and Attainment Summary Real Time" , it does not include this "Incentive Compensation - Participant Compensation Plan Real Time"  SRP_COMP_PLAN_ID field so the ATTAINMENTS values are all sum up to the compensation plan level which is showing the same value.

STEPS
1. Assign compensation plan to participant via Participant Snapshot > Manage Compensation Plan
    comp plan (CP1) for 1/1/19 - 9/30/19
    comp plan (CP1) for 10/1/19 - 12/31/19
2. Modify the quotas for 10/1/19 - 12/31/19 periods
3. Run calculation
4. Create report :
    SELECT "Participant"."Participant" saw_0,
                "Participant Plan Component Details"."Compensation Plan ID" saw_1,
                 sum(ifnull(filter("Incentive Compensation - Earning and Attainment Summary Real Time"."- Attainment Summary"."Output Achieved PTD" using
                     ("Incentive Compensation - Participant Compensation Plan Real Time"."Plan Component"."CN_PLAN_COMPONENTS_DFF_PC_TYPE_v"= 'Quota 1'
                AND "Incentive Compensation - Earning and Attainment Summary Real Time"."- Performance Measure"."CN_MEASURES_DFF_PM_TYPE_v"= 'Attainment (YTD Sales)')),0)
                BY "Participant Plan Component Details"."Compensation Plan ID") saw_2,
                "Participant Compensation Plan"."Start Date" saw_3,
                "Participant Compensation Plan"."End Date" saw_4,
                "Compensation Plan"."Compensation Plan" saw_5,
                   descriptor_idof("Incentive Compensation - Participant Compensation Plan Real Time"."Participant"."Participant") saw_6,
                   descriptor_idof("Incentive Compensation - Participant Compensation Plan Real Time"."Compensation Plan"."Compensation Plan")saw_7
      FROM "Incentive Compensation - Participant Compensation Plan Real Time"
    WHERE descriptor_idof("Incentive Compensation - Participant Compensation Plan Real Time"."Participant"."Participant") = 52192

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.