Massive renaming of Unique Territory Number without affecting current assignments
SummaryMake the UTN correspond to our ERP territory FK to simplify integration
Until the appearing of the Unique Territory Number [UTN] we managed the sales territory imports/exports with the TerritoryVersionId, but this new key simplifies the managing of territories. Thanks Oracle!
However, the UTN assigned by default to existing sales territories was sequential, and it keeps the same existing issue (we don't know the correspondence of the territories unless we export it) but with a sorter key . So we're facing the challenge to reassign the UTN to make it correspond with the ERP foreign key without generating a chaos in the current assignment of opportunities