BI Report on Attainment And Transaction Real Time Not Displaying Descriptive Flexfield Attributes (Doc ID 2072185.1)

Last updated on NOVEMBER 02, 2015

Applies to:

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

Symptoms

Report is not showing any transaction attributes for cross subject area join between Incentive Compensation - Attainment Real Time and Incentive Compensation - Transaction Real Time.

EXPECTED BEHAVIOR
Expecting to see the transaction attributes since it exists on the CN_TP_TRANSACTIONS_ALL table.

STEPS

1. Create cross subject area report between "Incentive Compensation Attainment Real Time" and "Incentive Compensation Transaction Real Time"
    Selected Columns :
         "Incentive Compensation - Attainment Real Time"."Calendar"."Period"
           "Incentive Compensation - Attainment Real Time"."Participant"."Participant Name"
         "Incentive Compensation - Transactions Real Time"."Participant"."Participant Name"  (Direct Rep Name)
         "Incentive Compensation - Attainment Real Time"."Source Transaction Details"."Source Transaction Number"
         "Incentive Compensation - Transactions Real Time"."Source Transaction Details"."Source Transaction Number"  (Hiding)
         "Incentive Compensation - Transactions Real Time"."Source Transaction Details"."Base Transaction_ACV__25_"   ( custom attribute10 )
         "Incentive Compensation - Transactions Real Time"."Source Transaction Details"."Base Transaction_ACV__25_"*"Attainment Transaction"."Credit Amount Home Currency"
         "Incentive Compensation - Transactions Real Time"."Type"."Transaction Type"
         "Incentive Compensation - Attainment Real Time"."Attainment Transaction"."Credit Amount Home Currency"
         "Incentive Compensation - Transactions Real Time"."Transaction"."Transaction Amount Source Currency"
         "Incentive Compensation - Transactions Real Time"."Transaction"."Transaction Quantity"
    Filters:
          Period = MAY-2015
          Source Transaction Number begins with 3784352

For sample transaction "3784352-May15-1", there are three attainment records but only 1 record shows the transaction attributes (eg. ACV% = 1).
The Direct Rep Name is also incorrect.  It should show  James Miles for all three record.

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