My Oracle Support Banner

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

Last updated on MARCH 19, 2019

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.

 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


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