My Oracle Support Banner

Fusion Global HR: How to Limit HCM Extract to the First Attribute Retrieved Such As the Driver's License for a User from the First Row? (Doc ID 2257107.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.04.0 and later
Oracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Information in this document applies to any platform.
This note was created for Release 11.1.11.1.0. The note has been reviewed and is current for release 11.13.20.04.0.

Goal

Is there a way to limit the HCM Extract to the first attribute retrieved?The goal is to fetch the first row of multiple records.

Because date values could be different for different records you cannot write a condition based on date value. Instead, use ’rownum’ in advanced filter criteria to fetch the first row of multiple records.>

  1. All Person Records need to be retrieved.
  2. For each person record, retrieve only the first driving license. Any succeeding license must not be retrieved per person. Using date as filter criteria cannot be used. Only first record needs to be picked up by HCM extract.

The user wants to extract the driver's license in the first row for an individual using the following user entities (UEs). In this example, the driver's license in the first row should be fetched for the extract.

Root Data Group: PER_EXT_SEC_PERSON_UE
Attributes:
-------------
- Person ID
- Person Number
- Person Last Name
- Person First Name

Child Data Group: PER_EXT_DRIVING_LICENSE_UE
Attributes:
--------------
- Extract Driving License Number

 

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.