Search Results jai_cmn_rg_comp_dtls

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:

• HR Objects: HR_ALL_POSITIONS_F (assigns a location to a position), HR_ALL_ORGANIZATION_UNITS (assigns a location to a department or business unit), and HR_LOCATION_EXTRA_INFO (stores flexible extra descriptive information).
• Financials Objects: AP_SYSTEM_PARAMETERS_ALL (default location for Payables), FINANCIALS_SYSTEM_PARAMS_ALL (Bill-To and Ship-To locations), and AR_TAX_EXTRACT_DCL_ITF (legal entity location).
• Supply Chain & Manufacturing Objects: BOM_DEPARTMENTS, CSI_A_LOCATIONS, and JAI_CMN_INVENTORY_ORGS.
• Common APIs: For programmatic access and validation, the HR_LOCATION API (HR_LOCATION_API) is the supported interface for creating, updating, and deleting location records, rather than direct DML on the table.