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:
Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.19.07.0 and laterInformation 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 |