'SQLERRM : ORA-01403: no data found' When Participant Plan Assignment Ended Early And Enable ‘Calculate End Dated Participants’ flag in PC (Doc ID 3039287.1)

Last updated on AUGUST 19, 2024

Applies to:

Symptoms

Calculation Process ends in ERROR status and see error "SQLERRM : ORA-01403: no data found" in the log file -

Log file shows -

API cn_tp_calc_util.calculate_init completed successfully
calculate_quota.others
100
ORA-01403: no data found
calculate_quota.others
100
ORA-01403: no data found
cn_tp_calculations_pvt.calculate_plan_component.others
SQLCODE : 100
SQLERRM : ORA-01403: no data found
End of cn_tp_calculations_pvt.calculate_plan_component with error
API cn_tp_calculations_pvt.calculate_plan_component has failed for participant : ######, comp plan : ###################, plan component : ##################, formula : ####################, period : 2024004 <participant name> <plan component name>
cn_tp_calculations_pvt.calculate_comp_plans.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
API cn_tp_calculations_pvt.calculate_comp_plans has failed
Unexpected Error SQLCODE=100:SQLERRM=ORA-01403: no data found

Changes

End dated the plan assignments for participants earlier than the end of the period intervals.

Setting and removing the checkmark for ‘Calculate End Dated Participants’ in the Incentive Formula tab of the plan components.

Cause

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