Add TerritoryId To The Territory Header Extract

(Doc ID 2250369.1)

Last updated on JULY 11, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 to 11.12.1.0.0 [Release 1.0]
Information in this document applies to any platform.

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.

Please raise an ER to include 'TerritoryId' in the TERRITORY HEADER extract file.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms