My Oracle Support Banner

Issue When Updating Cn_quota_rule_uplifts Mandatory Parameters Using Pub Api (Doc ID 403767.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 11.5.10 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

How to create create uplifts record with default accelerator values.
when no existing records in current Plan Element
as passing parameters as :

CN_PLAN_ELEMENT_PUB.Update_Plan_Element
( p_api_version => g_api_ver,
x_return_status => l_v_return_status,
x_msg_count => l_v_msg_count,
x_msg_data => l_v_msg_data,
p_new_plan_element_rec => l_plan_element_rec,
p_quota_name_old => l_old_quota_nm,
p_revenue_class_rec_tbl => l_rev_class_rec_tbl,
p_rev_uplift_rec_tbl => l_rev_uplift_rec_tbl, -- Pass Null value here
p_trx_factor_rec_tbl => l_trx_factor_rec_tbl,
x_loading_status => l_loading_status
) ;

If l_rev_uplift_rec_tbl is passed as Null value here
then below error occurs :

p_rev_uplift_rec_tbl.delete ;
p_rev_uplift_rec_tbl(1).rev_class_name := p_rev_class_stage_rec.rev_class_nm
;
p_rev_uplift_rec_tbl(1).start_date :=
nvl(p_rev_class_stage_rec.start_dt,l_start_date) ;
p_rev_uplift_rec_tbl(1).end_date :=
nvl(p_rev_class_stage_rec.end_dt,l_end_date); -- end date cn_api.g_miss_date,
if null, will give error.
p_rev_uplift_rec_tbl(1).rev_class_payment_uplift :=
nvl(p_rev_class_stage_rec.ACC_PYMT_PCT,l_payment_factor); -- default to 100
p_rev_uplift_rec_tbl(1).rev_class_quota_uplift :=
nvl(p_rev_class_stage_rec.ACC_QUOTA_PCT,l_quota_factor); -- default to 100
p_rev_uplift_rec_tbl(1).rev_class_name_old :=
p_rev_class_stage_rec.rev_class_nm ;
p_rev_uplift_rec_tbl(1).start_date_old := l_start_date ;-- THIS WILL BE NULL
for our Case.
p_rev_uplift_rec_tbl(1).end_date_old := l_end_date ; -- THIS WILL BE NULL
for our Case.



Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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