My Oracle Support Banner

Fusion HCM Extract: Which UE Can Be Used To Extract Jobfamily Names In Multiple Languages (Doc ID 2183708.1)

Last updated on APRIL 07, 2019

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.


Which UE can be used to extract jobfamily names in multiple languages?

PER_EXT_SEC_HISTORY_JOB_UE only contains the jobfamily_id, not the language nor the jobfamily_name
PER_EXT_JOB_FAMILY_TL_UE contains the language but not the name
PER_EXT_JOB_FAMILY_UE contains the jobfamily_name, but not the language
PER_JOB_JOB_DETAILS_UE contains the jobfamily_name, but not the language (it uses the user environment language to select the correct name)
HRT_EXT_PERSON_CAREER_PREFERENCE_UE contains the translated name, but not the language (nor the job(family)_id in order to reference this UE)
PER_EXT_JOB_FAMILY_UE contains the jobfamily_name and id, but no reference to the language...


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.