Calculation Error ORA-04061: existing state of package body "FUSION_DYNAMIC.ADXX_CN_FORMULA_14004_PKG" has been invalidated (Doc ID 2250384.1)

Last updated on MARCH 31, 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 errors.


ERROR
cn_tp_calculations_pvt.calculate_plan_component.others
SQLCODE : -4061
SQLERRM : ORA-04061: existing state of has been invalidated
ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "FUSION_DYNAMIC.ADXX_CN_FORMULA_15019_PKG" has been invalidated
ORA-04065: not executed, altered or
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 : 12 and for phase 1


STEPS
1. User 1 submit calculation
2. While calculation is still running, User 2 made a change to the performance measure expression.

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