Run All Participant Processes Import Issues Create Overlapping Participant Details Effective Start Date Records (Doc ID 2369549.1)

Last updated on FEBRUARY 07, 2025

Applies to:

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

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