Performance Measure Giving Error : SQLERRM : ORA-20202: ORA-24344: success with compilation error (Doc ID 1639507.1)

Last updated on NOVEMBER 05, 2016

Applies to:

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

Symptoms

On :  11.1.7.0.0 version, Manage Incentive Comp

When attempting to compile a performance measure PM_CCO_CC_TOTAL_CARDS with expression as - COUNT ( Plan component result.PC_CCO_CC_SALE_POINT.Earning Amount ),
where PC_CCO_CC_SALE_POINT is a per event plan component.

The following error occurs from compilation log and from standard package : CN_TP_FORMULA_GEN_PKG.generate_formula.OTHERS




ERROR
-----------------------
Need to check further
The application could not generate the PL/SQL package for the formula. Contact your system administrator. (CN-1575389)

CN:::CN_CPSTP_FORMPKG_GEN_FAIL_E

l_trx_rec_new.org_id := p_org_id ;
cn_message_pkg.debug('Exception occurs while calculating commission line: ');
cn_message_pkg.debug(sqlcode);
cn_message_pkg.debug(sqlerrm);
END ;
IF l_endofinterval_flag = 'Y' THEN
cn_tp_calc_util.create_update_grp_measure(l_trx_rec_new);
END IF;
g_output_achieved_ptd := l_commission - g_output_achieved_itd;
g_output_achieved_itd := l_commission;
g_commission_paid_ptd := l_commission - g_commission_paid_itd;
g_commission_paid_itd := l_commission;
cn_tp_calc_util.calculate_roll( p_participant_id,
p_plan_component_id, p_formula_id, p_period_id,
p_srp_comp_plan_id, 'N',
g_input_achieved_ptd, g_input_achieved_itd,
g_output_achieved_ptd, g_output_achieved_itd,
errbuf, retcode );
EXCEPTION
when others then
cn_message_pkg.debug('Exception occurs in formula calculate_quota:');
cn_message_pkg.debug(sqlcode);
cn_message_pkg.debug(sqlerrm);
raise;
END calculate_quota;
END ADXX_CN_FORMULA_95047_PKG;
In the exception block of pkg_end
SQLCODE = -20202
SQLERRM = ORA-20202: ORA-24344: success with compilation error
In the exception block of create_formula : OTHERS
SQLCODE : -20202
SQLERRM : ORA-20202: ORA-24344: success with compilation error
ERRBUF: Empty
Unexpected exception in create_formula
CN_TP_FORMULA_GEN_PKG.generate_formula.OTHERS
SQLCODE : -20202
SQLERRM : ORA-20202: ORA-24344: success with compilation error



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
A)
Navigace > Compensation Plan > Manage Performance Measure > Opened PM_CCO_CC_TOTAL_CARDS
> Save and get error

Checked that scorecards dimension number is null
Hide Reason
The application could not generate the PL/SQL package for the formula. Contact your system administrator. (CN-1575389)



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot .

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