Payment Real Time Subject Area Shows the Home Earning Amount 3x the Amount It Should Be (Doc ID 2191966.1)

Last updated on OCTOBER 11, 2016

Applies to:

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

Symptoms


ACTUAL BEHAVIOR
Home Earning Amount showing triple the correct amount.


STEPS
1. Created new BI analysis based on "Incentive Compensation - Payment Real Time" subject area.
2. Select following fields
SELECT
  0 s_0,
  "Incentive Compensation - Payments Real Time"."Calendar"."Period Name" s_1,
  "Incentive Compensation - Payments Real Time"."Participant"."Participant Name" s_2,
  "Incentive Compensation - Payments Real Time"."Payment Status"."Payment Status" s_3,
  "Incentive Compensation - Payments Real Time"."Plan Component"."Plan Component Name" s_4,
  DESCRIPTOR_IDOF("Incentive Compensation - Payments Real Time"."Calendar"."Period Name") s_5,
  SORTKEY("Incentive Compensation - Payments Real Time"."Calendar"."Period Name") s_6,
  "Incentive Compensation - Payments Real Time"."Payment Transaction"."Commission Amount Home Currency" s_7,
  "Incentive Compensation - Payments Real Time"."Payment Transaction"."Pay Amount Home Currency" s_8
FROM "Incentive Compensation - Payments Real Time"
WHERE
("Calendar"."Period Year" = '2016')
ORDER BY 1, 3 ASC NULLS LAST, 7 ASC NULLS LAST, 5 ASC NULLS LAST, 4 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

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