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 --.
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.
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%.
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.