Calculation Error ORA-01403: no data found Due to Missing Interval Distribution Record For Performance Measure (Doc ID 1604015.1)

Last updated on NOVEMBER 05, 2016

Applies to:

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

Symptoms

Run calculation and process errors.

ERROR
Before calling the dynamic package with stmt : begin ADXX_CN_FORMULA_28007_PKG.calculate_quota(:srp_comp_plan_id, :participant_id, :period_id, :start_date, :plan_component_id, :formula_id, :process_all_flag, :intel_calc_flag, :org_id, :cal
cn_tp_calc_util.calculate_init.g_exc_error
SQLCODE : 100
SQLERRM : ORA-01403: no data found
Output=0
Error in the procedure cn_tp_calc_subledger_pvt.update_srp_form_subledger
SQLCODE : 100
SQLERRM : ORA-01403: no data found
API cn_tp_calc_subledger_pvt.update_srp_form_subledger has failed
cn_tp_calc_util.calculate_roll.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
Exception occurs in formula calculate_quota:

STEPS
Navigator > Incentive Compensation > Calculate

Changes

 Instance just upgraded.

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