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

Last updated on NOVEMBER 27, 2023

Applies to:

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

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