Calculation Error cn_tp_calc_util.get_rates.l_invalid_rate_tier ORA-01403: No Data Found Due to Missing Conversion Rates (Doc ID 2213833.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

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

Symptoms


Calculation job completed with Error status.

 

ERROR MESSAGE (From Debug Messages)

...

API ADXX_CN_FORMULA_54011_PKG completed successfully
Interval Number : 2016012
API cn_tp_calc_util.calculate_init completed successfully
Earning (ID = 230957)
Rate Dim Sequence : 1
String Input : NON_REVENUE
Base Amount : 0
Done with get_input
Processing participant : 44013, plan componnent : 300000002746096, formula : 300000002746098, rate table 300000002887009
cn_tp_calc_util.get_rates.l_invalid_rate_tier
No matching rate
Exception occurs while calculating commission line:
1
User-Defined Exception
cn_tp_calc_util.update_earning.others
SQLCODE : 100
SQLERRM : 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 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 : 44013, comp plan : 300000002746089, plan component : 300000002746096, formula : 300000002746098, period : 2016012
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 ORA-01403: no data found
l_error_code = 100
Raising the 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 : 1 and for phase 1



STEPS
Navigator > Credits and Earnings > Manage Calculation Processes  (submit calculation for a specific participant)

 

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