Include Party ID Of Employee Record As Part Of The TERR_RESOURCE Extract (Doc ID 2250371.1)

Last updated on APRIL 13, 2017

Applies to:

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

Goal

On : 11.12.1.0.0 version, Territory Management, Quotas

ER: Include Party ID of employee record as part of the TERR_RESOURCE extract.
Working on documenting relationships between the export files of all entities. For the same,  need to identify the relationship between Employee Resource extract and the Territory Resource extract.On extracting Territory object from Manage File Export activities, there are 4 csv files:-
TERR_COVERAGE
TERR_HEADER
TERR_LOB
TERR_RESOURCE

In the TERR_RESOURCE extract, there are only "ResourceEmail" and "DisplayResourceName" columns to identify the employee resource.

This makes it a difficult task to locate the exact resource within the EmployeeResourcePVO extract.

Hence, it would be more convenient if there was a column containing the Party ID of the employee resource available as part of the TERR_RESOURCE extract.

If the employee resource's unique identifier is present in the TERR_RESOURCE extract file, then it would be easy to use it and look it up within the EmployeeResourcePVO extract.
 

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