Add TerritoryId To The Territory Header Extract (Doc ID 2250369.1)

Last updated on MARCH 19, 2019

Applies to:

Goal

Add TerritoryId to the Territory Header extract

Exported Territory related objects from Scheduled Export Processes.
In the TERRITORY HEADER, TERRITORY COVERAGE and TERRITORY RESOURCE extracts, there is column named 'Territory Number' which stores the unique id associated with the territory.
Whereas in the case of TerritoryExpPVO it contains a column named 'TerritoryId'.
As there no common unique identifier across these sheets, hence it not possible to derive a relationship between these extracts.
Had 'TerritoryId' been a part of the TERRITORY HEADER extract then it would be convenient to understand the relationship across the sheets.

 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.