Skip to main content
OracleOps AI
← All tables
Oracle Fusion/HCM/Global HR

HR_ALL_ORGANIZATION_UNITS_F

Organizations — date-effective base rows for departments, legal entities, business units and divisions.

Key Columns

ORGANIZATION_IDEFFECTIVE_START_DATEEFFECTIVE_END_DATECLASSIFICATION_CODELOCATION_ID

Child Tables

HR_ORGANIZATION_UNITS_F_TL

Translated organization names — join to resolve the display name of a department or business unit.

Common Joins

HR_ORGANIZATION_UNITS_F_TLvia ORGANIZATION_ID + LANGUAGE

The organization's translated name.

Used In

Global HRFinancials

Related

HCM work structures: jobs, grades, positions, organizations

Assignments reference jobs (PER_JOBS_F), grades (PER_GRADES_F), positions (HR_ALL_POSITIONS_F) and organizations (HR_ALL_ORGANIZATION_UNITS_F, names in HR_ORGANIZATION_UNITS_F_TL). Locations live in HR_LOCATIONS_ALL.

Ask Oracle AI about HR_ALL_ORGANIZATION_UNITS_F