My Oracle Support Banner

Incentive Compensation Multiple Cross Subject Areas Joins on Compensation Plan Returns Duplicate Records (Doc ID 2326675.1)

Last updated on MARCH 24, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Oracle Fusion Incentive Compensation Cloud Service - Version 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.



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.