Search Results hr_locations_all




Overview
Explore in AI Chat

Overview

The HR_LOCATIONS_ALL table is a core master data table within the Oracle E-Business Suite (EBS) Human Resources (HRMS) module. It serves as the central repository for defining and storing all physical work location addresses used across the enterprise. Its role extends far beyond the HRMS module, acting as a critical reference point for numerous other EBS applications, including Financials, Supply Chain, and Projects. The table supports multi-organization architecture through its BUSINESS_GROUP_ID column, allowing location definitions to be partitioned and secured by business group. As a foundational "T" table in the Application Object Library's data model, it provides a standardized, reusable definition for any place of business, which is then referenced by other entities like departments, positions, and organizations.

Key Information Stored

The table stores comprehensive address and descriptive information for each work location. The primary identifier is the system-generated LOCATION_ID. A unique combination of LOCATION_CODE and BUSINESS_GROUP_ID forms an alternate key, ensuring location codes are unique within a business group. Key descriptive columns include LOCATION_CODE (a short identifier), DESCRIPTION, and a full set of address fields (ADDRESS_LINE_1 through ADDRESS_LINE_3, TOWN_OR_CITY, COUNTRY, POSTAL_CODE, and REGION_1/2). The table also includes standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing and the BUSINESS_GROUP_ID for security and partitioning.

Common Use Cases and Queries

This table is integral for reporting, data validation, and integration tasks. Common use cases include generating master lists of all company locations, validating address data for compliance, and supporting operational reports for headcount or asset distribution by location. A typical query to retrieve active locations for a specific business group would be:

  • SELECT location_code, description, address_line_1, town_or_city, country FROM hr_locations_all WHERE business_group_id = &bg_id ORDER BY location_code;

For integration or data migration, developers often query this table to obtain the LOCATION_ID for use in populating foreign key columns in dependent tables, such as HR_ALL_POSITIONS_F or HR_ALL_ORGANIZATION_UNITS. It is also frequently joined with HR_ORGANIZATION_UNITS to map organizations to their physical addresses.

Related Objects

As indicated by the extensive foreign key relationships in the metadata, HR_LOCATIONS_ALL is a highly referenced table. Key related objects include: