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 to set the length of Product_Attainment_vod__c to be 3. From the product perspective, the value of attainment should not exceed 999%.
Related Documentation:
N/A
Send us your feedback: We're always looking for advice to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.
Thank you