My Oracle Support Banner

Fusion Global HR: How to Create an HCM Extract that Provides Delta Data on Person IDs (Changes Since Last Extract) when Trying to Join PER_EXT_SEC_PERSON_UE and PER_PER_PERSON_DETAILS_UE (Doc ID 2045084.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.07.0 and later
Oracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Information in this document applies to any platform.
This note was created for Release 11.1.9.2.0. The note has been reviewed and is current for release 11.13.20.04.0.
Currency checked on 1-FEB-2017

Goal

While creating a HCM Extract that will provide delta data (changes since last Extract), when trying to join PER_EXT_SEC_PERSON_UE and PER_PER_PERSON_DETAILS_UE (thru data groups) noticed that PER_PER_PERSON_DETAILS_UE does not have Person ID database item in this UE.

This renders the PER_PER_PERSON_DETAILS_UE useless. Can the PER_PER_PERSON_DETAILS_UE be amended and Person ID added in the UE?
 

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.