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 and later
Information in this document applies to any platform.


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.


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