How to Restore an End Dated Territory and its Related Child Data in Veeva Align?
This scenario may occur during an accidental end dating action via the Align UI or Align Dataloader.
End dating territories is referred to as Territory closures. In turn, extending or reopening Territories mean their restoration.
The process is not trivial and requires intermediate/expert understanding of Veeva Align, data management, data manipulation.
If possible, recreating the territory with a different name and dataload its child data again are the safest and easier way to proceed with.
However, in the event creating a new territory is not an option, the aim of this article is to explain a basic guideline of restoration of child records/assignments having standard and special sources, especially Inherited records/assignments. (Created by Align or Vault triggers)
The steps are as follows, be sure to follow them in order:
I. Remove all Integration Status 2 records of the territory and its related child records/assignments
The first step is to extract and remove all IS2 records associated to the territory. This includes all Account Territory, Territory Product, Roster Member Territory, Territory IS2 records. This task can be efficiently done by using Vault Loader and VQL.
II. Restore the Territory record itself
The next step is about reverting the territory record itself back to its original state. Extend the end date back to the desired future date. In Business Admin or with Vault Loader, set CRM Is Deleted back to No (False).
III. Restore the standard assignments and child records of the territory
Account Territory assignments having the source of CRM, Align Manual, Import, MCCP (Rare), CRM Feedback can be restored by setting their CRM is Deleted to No (False) and extending their end dates into the desired future date.
This also applies to:
- Territory Products having the source of Import, Align Manual.
- Roster Member Territory records having the source of Import, Align Manual.
- Geography Territory assignments having the source of Import, Align Manual. They do not have the CRM is Deleted field.
Territory Level Account Rules and Territory Level Account Exclusion records only require their End dates to be set into the future.
IV. Restore Geography Territories having the source of Footprint
Geography Territories having the source of Footprints can be restored via the Territory Footprint records associated to the territory. Using the Align UI or Align Data Loader, the end date of the Territory Footprint records can be extended into the future with a desired value. The end date value of the Footprint sourced Geography Territories will be restored.
V. Restore Territory Product records having the source of Inheritance
Territory Products having the source of Inheritance can be restored by setting their CRM is Deleted field back to No (False), and extending their end dates to the desired future date. The connection between the Field Force Product and the Territory Product records are kept even if the Territory Products are edited in Business Admin or by Vault Loader.
VI. Restore Account Territory assignments having the source of Align Rule and/or Align Hierarchy Rule
Be sure to restore the Geography Territory and potential Territory Level Account Assignment Rules first, before running an Assignment Preview and Commit. Running an Assignment Preview and Commit on the affected Territory will recreate the Source = Align Rule / Align Hierarchy Rule Account Territory assignments. These are going to be new records entirely. The end dated records will stay as is.
VII. Push the Territory to Veeva CRM.
As the last step, a Push can now be run on the affected territory itself to get the data changes reflected in Veeva CRM.
- These steps are strongly disrecommended to base standard Align Business As Usual (BAU) Activities on.
- There may be more special cases or scenarios related to the affected territory.
- VQL Knowledge is required. (Due to the Where Clause in the Vault Loader Tab)
Align Help Documentation:
Send us your feedback: We are always looking for feedback to help improve our Knowledge Base! Please let us know if this article is helpful or provide feedback on how we can improve your experience by clicking here.