My Oracle Support Banner

How to Create a Report to Show the Direct Participant and Credited Participant (Doc ID 2606530.1)

Last updated on JUNE 17, 2020

Applies to:

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

Goal

Customer has a report that shows individual transactions.

Customer wants to add the direct participant on the transaction, in addition to the credited participant but currently using "Incentive Compensation - Credits Real Time", it only shows the Credited Participant (all other participant fields will show the same as credited participant):

 

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 
  "Incentive Compensation - Credits Real Time"."Credit Transaction Details"."Credited Participant Id" s_1,
  "Incentive Compensation - Credits Real Time"."Credited Participant Details"."Credited Participant" s_2,
  "Incentive Compensation - Credits Real Time"."Directly Credited Participant"."Participant" s_3,
  "Incentive Compensation - Credits Real Time"."Source Transaction Details"."Source Event Date" s_4,
  "Incentive Compensation - Credits Real Time"."Source Transaction Details"."Source Transaction Number" s_5,
  "Incentive Compensation - Credits Real Time"."Credit Transaction"."Credit Amount Calculated Currency" s_8
FROM "Incentive Compensation - Credits Real Time"
WHERE
("Source Transaction Details"."Source Transaction Number" = 55555)

 

How to get both details on a transaction?
 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.