My Oracle Support Banner

Fusion Global HR: Person Gender Database Item (DBI) Does Not Fetch Details As Expected into the HCM Extract (Doc ID 2529865.1)

Last updated on JULY 06, 2022

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.
This note was created for Release The note has been reviewed and is current for release


Used PER_EXT_SEC_PERSON_UE UE as Root User Entity (UE), and in this we used "Person Gender" DBI to fetch Gender Details.
This DBI is not directly related to PER_EXT_SEC_PERSON_UE, but fetches details from PER_PER_PERSON_DETAILS_UE UE using some contexts set automatically.

However, there are certain cases, where a person has two Legal Entities (in case of Legal Entity/Global Transfers), and both being ACTIVE and not being End Dated.

In these cases, the Extract is fetching Gender Details randomly into the Extract. But the goal is it to fetch only one Gender and that being the latest.


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

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