BI : Cross Subject Area Report On Credits and Transactions Real Time Is Not Returning Transaction Attributes When Filter On Credit Category.

(Doc ID 2073434.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

Created an BI cross subject area report based on "Incentive Compensation - Credits Real Time" and "Incentive Compensation - Transaction Real Time".

If include the Credit Category field, the report is returning too many records which is incorrect.

Sample Fields selected on the analysis :

"Incentive Compensation - Credits Real Time"."Calendar"."Period Name"
"Incentive Compensation - Credits Real Time"."Calendar"."Period Year"
"Incentive Compensation - Credits Real Time"."Credit Category"."Credit Category Name"
"Incentive Compensation - Credits Real Time"."Credit Transaction Details"."Credited Participant Name"
"Incentive Compensation - Credits Real Time"."Type"."Credit Type"
"Incentive Compensation - Transactions Real Time"."Source Transaction Details"."CN_TP_BASETRANS_DFF_KIM__ATTR1_"  (custom attribute1)
"Incentive Compensation - Transactions Real Time"."Source Transaction Details"."Source Transaction Number"
"Incentive Compensation - Credits Real Time"."Credit Transaction"."Credit Amount Calculated Currency"
"Incentive Compensation - Transactions Real Time"."Transaction"."Transaction Amount Source Currency"

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