Overview:
A MultiChannel Cycle Plan (MCCP) job fails with a processing error.
When searching for the Bulk Data Load Jobs, the following error is found:
NUMBER_OUTSIDE_VALID_RANGE:Product Attainment: value outside of valid range on numeric field: 1100.0:Product_Attainment_vod__c --.
Root Cause:
Product_Attainment_vod__c is a percent field. The length of the field is 3 characters, so the maximum value is 999.
This value is calculated by the formula: Product Interactions Earned / Product Interactions Goal.
When Product Interactions Earned has a value of 11 and the Product Interactions Goal has a value of 1, the Product_Attainment_vod__c changes to 1100. It exceeds the valid range of the field.
Solution:
Adjust the value of the Product Interactions Goal.
This is designed that the length of Product_Attainment_vod__c is 3. From the product perspective, the value of attainment should not exceed 999%.
Related Documentation:
N/A
Thank you