Fusion HCM Extract: Which UE Can Be Used To Extract Jobfamily Names In Multiple Languages

(Doc ID 2183708.1)

Last updated on DECEMBER 16, 2016

Applies to:

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

Goal

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

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