Cost Change Of Item With Original Unit Cost Set To Zero - Impossible To Approve Cost Change (Doc ID 3005903.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Symptoms

Cost change of item with original unit cost set to zero is impossible to approve. In the below example FUNCTION CHECK_SUPP_VARIANCES when calling the bellow cursor it will always return true and will fail the validations for unit cost change
the particular line ( and cssdl.unit_cost > (iscl.unit_cost + (iscl.unit_cost * (L_cost_pct_var/100))) will always return true for a scenario where the original cost = 0 :

cursor C_VAR_PCT
select 'X'
from item_supp_country_loc iscl,
cost_susp_sup_detail_loc cssdl
where cssdl.cost_change = I_cost_change
and cssdl.item = I_item
and cssdl.supplier = I_supplier
and cssdl.loc = I_location
and cssdl.origin_country_id = I_country
and cssdl.unit_cost > (iscl.unit_cost + (iscl.unit_cost * (L_cost_pct_var/100))) -- new unit cost > 0+(0*(supplier pct variance/100))
and cssdl.item = iscl.item
and cssdl.supplier = iscl.supplier
and cssdl.origin_country_id = iscl.origin_country_id
and cssdl.loc = iscl.loc
UNION ALL
select 'X'
from item_supp_country_loc iscl,
cost_susp_sup_detail_loc cssdl
where cssdl.cost_change = I_cost_change
and cssdl.item = I_item
and cssdl.supplier = I_supplier
and cssdl.loc = I_location
and cssdl.origin_country_id = I_country
and cssdl.unit_cost < (iscl.unit_cost - (iscl.unit_cost * (L_cost_pct_var/100)))
and cssdl.item = iscl.item
and cssdl.supplier = iscl.supplier
and cssdl.origin_country_id = iscl.origin_country_id
and cssdl.loc = iscl.loc;

This validation will always set the Cost Conflict_Check with error “FAILED_SUPP_VAR_CHECK”


ERROR :
-----------------------
FAILED_SUPP_VAR_CHECK


STEPS TO REPRODUCE :
-----------------------
1. Option created with unit_cost = 0.00
2. Raise a cost change for the option to any value
3. Cost change will fail with error “FAILED_SUPP_VAR_CHECK”

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.