Incentive Compensation Multiple Cross Subject Areas Joins on Compensation Plan Returns Duplicate Records
Last updated on DECEMBER 08, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 184.108.40.206.0 and later
Oracle Fusion Incentive Compensation Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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.
One effective start date record should come under Compensation Plan SA
Create analysis using the four seeded subject areas.
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