My Oracle Support Banner

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 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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.