Overview:
While querying the Sent_Email_vod object, it is noticed that the Territory_vod field is null on multiple records.
Root Cause:
Territory_vod is not always on the Sent_Email_vod object. This field was added after Approved Email (AE) became available. This can result in some Sent_Email_vod records which have a null Territory_vod field. It is also possible that there is no Territory match between the end-user and account.
Solution:
First, ensure the end-user profile has Read Field Level Security (FLS) to the Sent_Email_vod.Territory_vod field. Second, it is important to understand how the Sent_Email_vod.Territory_vod field is updated. Below is a brief description in regard to which territory is stamped to the Territory_vod field:
- If the User and Account are in more than one territory, the first territory from the User that matches a territory of the Account is used.
- If no match between User and Account, the Territory_vod field is not populated on the Sent Email record
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