How to handle Null Values in Formulas
During formula calculation, if a step results in a null value, the formula fails.
Example :
consider the formula 1*2, where step 2 is of type Pricing Attribute.
The pricing attribute context is Physical Attribute & the pricing
attribute is Volume.Hence we must provide the volume at order entry
time.
If we can't provide a volume, use the NVL expression in the
formula to refer to a step number that evaluates to a non-null value.In
this case we can change the formula to 1* NVL(2,3). In the formula line
for step number 3, use a non-null value such as the numeric constant of
7. If the user does not provide a value for volume, the pricing engine
uses 7 in the formula calculation.
If the expression does not use
NVL in the expression, and the step number evaluates to NULL, the entire
expression evaluates to NULL, the formula calculation fails, and the
calling application processes the failure.
No comments:
Post a Comment