My Oracle Support Banner

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

Last updated on MARCH 27, 2019

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

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.