Incentive Compensation Multiple Cross Subject Areas Joins on Compensation Plan Returns Duplicate Records

(Doc ID 2326675.1)

Last updated on DECEMBER 08, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Incentive Compensation Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

User created an analysis with cross subject area query on the following four subject areas ( SA) :
1. Incentive Compensation - Attainments Real Time
2. Incentive Compensation - Earnings Real Time
3. Incentive Compensation - Participant Compensation Plan Real Time
4. Incentive Compensation - Transactions Real Time

When adding Participant.participant_id to the query, attributes from the Transaction SA does not returning properly.
This is due to that Participant Dimension is used as confirmed dimension and participant_id is not populated for transaction.

When adding Directly Credited Participant, there many more rows of data from Participant Compensation Plan SA.
This is because Directly Credited Participant is not confirmed dimension for Participant Compensation Plan SA.
The join between Participant Compensation Plan SA and Earning SA will have the participant_id missing.
This causes participant compensation assignment dates is returning too many records.


EXPECTED BEHAVIOR
One effective start date record should come under Compensation Plan SA

STEPS
Create analysis using the four seeded subject areas.

 

Cause

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