Fusion Global HR: How to Limit HCM Extract to the First Attribute Retrieved?

(Doc ID 2257107.1)

Last updated on JULY 10, 2017

Applies to:

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

Goal

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

Is there a way to limit HCM Extract to the first attribute retrieved?

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.
 

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