Earnings Are Duplicated Due to Overlapping Calculation Submission For Same Parameters
(Doc ID 2829113.1)
Last updated on MARCH 30, 2022
Applies to:Oracle Fusion Incentive Compensation Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
After calculation process , user see that there are duplicated earnings with same compensation_plan, plan component, participant, source_trx_number and earning amount.
Sample query result for specific participant and transaction number.
select /* Doc ID 2829113.1 */
earning_id, object_status, comm_amt_calc_curr, creation_date, request_id
where source_trx_number = '1000344928084'
and transaction_type = 'ACT_B'
and credit_id = 135829089
and credited_participant_id = 63576
and srp_comp_plan_id = 297882
and plan_component_id = 300000104958247
EARNING_ID OBJECT_STATUS COMM_AMT_CALC_CURR CREATION_DATE REQUEST_ID
16066077003 CALCULATED 8.995 2021-11-26 19:47:02 4040408
16066076731 CALCULATED 8.995 2021-11-26 19:30:53 4040261
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