Run All Participant Processes Import Issues Create Overlapping Participant Details Effective Start Date Records

(Doc ID 2369549.1)

Last updated on MARCH 05, 2018

Applies to:

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

Symptoms

The CollectParticipantJob process from parent jobset Run All Participants Processes  created overlapping participant detail record which
cause calculation to error with ORA-01422: exact fetch returns more than requested number of rows.



The calculation process ended up with the following error.
ERROR
cn_tp_calculations_pvt.calculate_plan_component.others
SQLCODE : -1422
SQLERRM : ORA-01422: exact fetch returns more than requested number of rows
End of cn_tp_calculations_pvt.calculate_plan_component with error
cn_tp_calculations_pvt.calculate_comp_plans.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
cn_tp_calculations_pvt.calculate.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
End of cn_tp_calculations_pvt.calculate for physical batch id : -999 and for phase 1



STEPS
1. Setup definition to import participants and collect attributes

    1) Manage Participant Import Mappings
    2) Manage Participant Selection Rules
2. Submit Run All Participant Processes to create participants
    Navigator > Participant Assignments > Run All Participant Processes
3. Load transactions and calculate commission
    Navigator > Credits and Earnings > Run All Transaction Processes

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms