Fusion Global HR: How to Design an HCM Extract for Active Employees with Special Criteria for Rehire

(Doc ID 1947629.1)

Last updated on FEBRUARY 01, 2018

Applies to:

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


For an extract in which Person block is Root Block and Assignment is Child Block and these are joined based on Person Id:

The requirement is to extract only the Employee's Active Assignment, in case of Rehired employees.
But if it is not a case of rehire, both Active and Inactive Assignment details need to be extracted.

How can this be accomplished?


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