Search Results HR_ALL_ORGANIZATION_UNITS




Overview
Explore in AI Chat

Overview

The HR_ALL_ORGANIZATION_UNITS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically under the Sales Foundation module. As indicated by its "Retrofitted" description, it is a foundational table that has been adapted for broader use across the application suite. Its primary role is to serve as the master repository for all organizational unit definitions within the enterprise. An organizational unit is a flexible entity representing any logical grouping within a business, such as departments, divisions, cost centers, sales offices, or project teams. This table enables the structural modeling of the enterprise hierarchy, which is critical for security profiles (e.g., Security Groups in Oracle HRMS), reporting, workflow routing, and transactional data segregation across various EBS modules.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, based on its standard function and naming convention, the table typically stores metadata that defines each unique organizational entity. Key columns generally include:

  • ORGANIZATION_ID: The primary key, unique identifier for the organizational unit.
  • NAME: The descriptive name of the organization (e.g., "Northwest Sales Division").
  • TYPE: A code classifying the organization (e.g., DEPARTMENT, COMPANY, LINE_OF_BUSINESS).
  • DATE_FROM / DATE_TO: Columns defining the active date range of the organization, supporting effective-dated structures.
  • LOCATION_ID: Foreign key to the HR_LOCATIONS table, linking the organization to a physical address.
  • INTERNAL_EXTERNAL_FLAG: Designates if the organization is internal to the enterprise or an external entity.

This structure supports complex, time-aware organizational hierarchies managed via the HR_ORGANIZATION_UNITS table and its associated APIs.

Common Use Cases and Queries

This table is central to organizational reporting and data security. A common use case is generating a current list of all active internal departments for a management report. Another critical use is within Security Profiles, where the ORGANIZATION_ID is used to restrict user access to data. A typical query pattern involves joining to related tables for descriptive information.

Sample Query: List Active Organizations
SELECT ORGANIZATION_ID, NAME, TYPE
FROM HR_ALL_ORGANIZATION_UNITS
WHERE SYSDATE BETWEEN DATE_FROM AND NVL(DATE_TO, SYSDATE)
AND INTERNAL_EXTERNAL_FLAG = 'INTERNAL'
ORDER BY NAME;

For reporting in Oracle Reports or BI Publisher, this table is often the primary source for organization parameters and descriptive flexfield data related to organizational structures.

Related Objects

HR_ALL_ORGANIZATION_UNITS is intrinsically linked to numerous other EBS objects. The primary related table is HR_ORGANIZATION_UNITS, which holds the effective-dated history and hierarchical relationships (via PARENT_ORGANIZATION_ID). The PER_ALL_PEOPLE_F table links assignments to organizations. Key APIs, such as HR_ORGANIZATION_API, are used to create and maintain records in this table programmatically. From a reporting perspective, it is commonly joined to HR_LOCATIONS for address data and referenced by views like PER_ORG_STRUCTURE_VERSIONS for hierarchy analysis. Its central role in the Sales Foundation module also implies integration with objects in Order Management and CRM.