Search Results hr_organization_units_uk2




Overview
Explore in AI Chat

Overview

The HR_ALL_ORGANIZATION_UNITS table is a core master data table within the Oracle E-Business Suite Human Resources (HRMS) module. It serves as the central repository for defining the organizational hierarchy, holding the definitions for both business groups and the individual organization units that exist within each business group. A business group represents the highest level of organization in HRMS and defines a complete, self-contained set of workforce information. This table is therefore fundamental to the security and data partitioning model of Oracle HRMS, as all subsequent employee, job, and position records are scoped within a specific business group. Its structure and constraints enforce data integrity across the complex organizational setups typical of global enterprises.

Key Information Stored

The table stores essential attributes for each organizational entity. The primary key is ORGANIZATION_ID, which uniquely identifies every record. A critical column is BUSINESS_GROUP_ID, which acts as the partitioning key, scoping each organization unit to a specific business group. The NAME column stores the organization's title. Together, NAME and BUSINESS_GROUP_ID form a unique constraint (HR_ORGANIZATION_UNITS_UK2), ensuring organization names are not duplicated within a single business group. Other significant foreign key columns include LOCATION_ID, linking to the HR_LOCATIONS_ALL table for address details, and COST_ALLOCATION_KEYFLEX_ID and SOFT_CODING_KEYFLEX_ID, which link to key flexfields for financial accounting. The table's design ensures that every organization, including the business group record itself, is stored as a row with its appropriate BUSINESS_GROUP_ID context.

Common Use Cases and Queries

This table is central to organizational reporting, security rule definitions, and data validation. A frequent requirement is to list all organizations within a specific business group, often for use in value sets or list of values (LOV). The column BUSINESS_GROUP_ID is pivotal for such filtered queries. Common SQL patterns include retrieving the organization hierarchy or validating an organization's existence within a user's security context. For instance, to find all active organization units for a given business group, a query would filter on BUSINESS_GROUP_ID and the relevant status column (often sourced from HR_ORGANIZATION_INFORMATION). Reporting on organizational structures, headcount roll-ups, and cost center allocations all depend on joins starting from this table.

Related Objects

The foreign key relationships documented in the ETRM metadata illustrate the table's central role. Key dependencies include:

  • Self-Referential: HR_ALL_ORGANIZATION_UNITS references itself on BUSINESS_GROUP_ID, linking child organizations to their parent business group record.
  • HR_LOCATIONS_ALL: Joined via LOCATION_ID to retrieve physical address details for an organization.
  • PAY_COST_ALLOCATION_KEYFLEX: Joined via COST_ALLOCATION_KEYFLEX_ID for financial costing information.
  • Dependent Tables: Several objects reference this table, including BEN_BENEFIT_CONTRIBUTIONS_F (on BUSINESS_GROUP_ID) and GHR_MASS_REALIGNMENT (on OLD_ORGANIZATION_ID and NEW_ORGANIZATION_ID), demonstrating its use in benefits and government HR processes.
  • HR_ORGANIZATION_INFORMATION: While not listed in the provided foreign keys, this is a critical related table that stores additional classifications and information types for each ORGANIZATION_ID, as noted in the overview.
These relationships underscore that HR_ALL_ORGANIZATION_UNITS is a foundational entity for organizational data within the HRMS schema.