Fusion Global HR: How to Design an HCM Extract for Active Employees with Special Criteria for Rehire (Doc ID 1947629.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Goal

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?
 

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