Fusion Global HR: Performance of User Account HCM Extract Extracting Employee Details (Doc ID 2161847.1)

Last updated on DECEMBER 21, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

As part of the performance improvement of an HCM Extract you cannot entirely remove the existing User Entity: PER_EXT_PAY_EMPLOYEES_UE & replace it with PER_EXT_SEC_ASSIGNMENT_BASIC_UE instead.

Some DBI's are not available at the Data Group Filter Criteria of the HCM Extract when you use PER_EXT_SEC_ASSIGNMENT_BASIC_UE
Below DBI's that you need to fulfill our existing filter criteria:

Extract Employee Assignment Primary Relationship Indicator, primary_assignment_flag from Assignment Record isn't available.
Assignment Relationship Actual Termination Date, actual_termination_date from Per Periods of Service isn't available.
 

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