Earnings Are Duplicated Due to Overlapping Calculation Submission For Same Parameters (Doc ID 2829113.1)

Last updated on MARCH 30, 2022

Applies to:

Symptoms

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
   from fusion.cn_tp_earnings_all
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

Cause

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