Question:
After running the Multichannel Cycle Plan (MCCP) Process in Veeva CRM Online, how can the following error be resolved: NUMBER_OUTSIDE_VALID_RANGE:Channel Attainment?
Answer:
In order to use this method, the full error message is needed. It is located in the Bulk Data Load text document when viewing results for the Records with errors.
The full error message appears below:
NUMBER_OUTSIDE_VALID_RANGE:Channel Attainment: value outside of valid range on numeric field: 1900.0:Channel_Attainment_vod__c
With this information, run the following query to identify the MC Cycle Plan Target record that is causing the error. Please note that the value of Channel_Attainment_vod__c on the MC Cycle Plan Target object is matched with the value provided in the error.
SELECT Channel_Attainment_vod__c,Target_vod__c FROM MC_Cycle_Plan_Target_vod__c WHERE Channel_Attainment_vod__c = 1900.0
Channel_Attainment_vod__c is calculated by dividing Channel_Interactions_Earned_vod__c by the Channel_Interactions_Goal_vod__c. If the Channel_Attainment_vod__c result is greater than 999.0, an error is encountered when running the MCCP Process.
The result of the query above produces the MC Cycle Plan Target ID that is causing the error. The MC Cycle Plan Target can then be adjusted so the result is less than 999.0.
This same process can be utilized to resolve the error if Product_Attainment_vod__c is in the error instead of Channel Attainment.
Related Documentation:
CRM Help Documentation: Multichannel Cycle Plans