Calculation User-Defined Exception ORA-06550 PLS-00201 identifier 'ADXX_CN_FORMULA_355001_PKG.CALCULATE_QUOTA' must be declared (Doc ID 2900467.1)

Last updated on JANUARY 12, 2024

Applies to:

Symptoms

Calculation Error

EXCERPT FROM DEBUG ERROR MESSAGES

549472346 Calling package ADXX_CN_FORMULA_355001_PKG
549472347 calculate_quota.others
549472348 -6550
549472349 ORA-06550: line 1, column 7: PLS-00201: identifier 'ADXX_CN_FORMULA_355001_PKG.CALCULATE_QUOTA' must be declared
549472350 cn_tp_calculations_pvt.calculate_plan_component.others
549472351 SQLCODE : -6550
549472352 SQLERRM : ORA-06550: line 1, column 7: PLS-00201: identifier 'ADXX_CN_FORMULA_355001_PKG.CALCULATE_QUOTA' must be declared
549472353 End of cn_tp_calculations_pvt.calculate_plan_component with error
549472354 API cn_tp_calculations_pvt.calculate_plan_component has failed for participant : 1249540, comp plan : 300000006164188, plan component : 300000007095025, formula : 300000007095027, period : 2021011
549472355 cn_tp_calculations_pvt.calculate_comp_plans.g_exc_error
549472356 SQLCODE : 1
549472357 SQLERRM : User-Defined Exception
549472358 API cn_tp_calculations_pvt.calculate_comp_plans has failed
549472359 Unexpected Error SQLCODE=-6550:SQLERRM=ORA-06550: line 1, column 7: PLS-00201: identifier 'ADXX_CN_FORMULA_355001_PKG.CALCULATE_QUOTA' must be declared
549472360 l_error_code = -6550
549472361 Raising the exception
549472362 cn_tp_calculations_pvt.calculate.g_exc_error
549472363 SQLCODE : 1
549472364 SQLERRM : User-Defined Exception


STEPS
1. Change the expression on an existing valid Performance Measures for a Plan Component
2. Run Deploy Compensation Plan
3. Run Calculation and process completed with error status

Enable profile CN_DEBUG = Yes and rerun calculation to see the debug messages to identify cause of error.

Changes

Cause

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