Search Results per_organization_units




Overview
Explore in AI Chat

Overview

The PER_ORGANIZATION_UNITS view is an Oracle E-Business Suite (EBS) reporting and integration object owned by the APPS schema and associated with the PER – Human Resources product. Its documented status is VALID, and in ETRM 12.2.2 metadata it is defined with references to the HR_GENERAL package, the HR_ORGANIZATION_INFORMATION synonym, the HR_ORGANIZATION_UNITS view, and the HR_SECURITY package. The view is described simply as “Lists information about Organization Units.”

In practice, the view exposes a filtered, report-friendly projection of the HR organization hierarchy. Because it restricts output to organization units classified as Human Resources organizations, it is commonly used by HRMS reports and integrations that need to enumerate valid HR organizations without embedding the classification logic directly into their SQL.

Underlying Base Objects

The view is defined over the HR organization model and selects from three sources that are joined on ORGANIZATION_ID:

  • HR_ORGANIZATION_UNITS O — the primary source of organization unit attributes, including name, dates, internal address, and key flexfield references.
  • HR_ORGANIZATION_INFORMATION O2 — joined with an outer join ((+)) and filtered to the WORK DAY INFORMATION context, supplying work day attributes (start time, end time, working hours, frequency).
  • HR_ORGANIZATION_INFORMATION O3 — joined to restrict the result set to units classified as HR organizations. The CLASS context is filtered where ORG_INFORMATION1 = 'HR_ORG' and ORG_INFORMATION2 = 'Y'.

The classification predicate on the O3 join is what makes the view specifically represent HR organizations rather than the full organization hierarchy stored in HR_ORGANIZATION_UNITS.

Key Columns

  • ORGANIZATION_ID — primary identifier of the organization unit; the join key to related HR tables.
  • BUSINESS_GROUP_ID — the business group to which the organization belongs, used for multi-organization filtering and security.
  • NAME — the organization unit name, commonly displayed in reports and lists of values.
  • DATE_FROM / DATE_TO — effective dates bounding the unit’s validity.
  • INTERNAL_ADDRESS_LINE and COMMENTS — descriptive attributes of the organization unit.
  • DEFAULT_START_TIME / DEFAULT_END_TIME / WORKING_HOURS / FREQUENCY — work day attributes sourced from the WORK DAY INFORMATION context.
  • INTERNAL_EXTERNAL_FLAG — indicates whether the organization is internal or external.
  • TYPE — the organization unit type.
  • LOCATION_ID — reference to the associated location.
  • COST_ALLOCATION_KEYFLEX_ID / SOFT_CODING_KEYFLEX_ID — key flexfield identifiers used for cost allocation and soft coding.

Common Use Cases and Queries

Typical scenarios include listing valid HR organizations for reporting, validating organization identifiers during data load, and joining organization names to employee or assignment data. Restricting by business group and effective dates is routine to avoid returning expired or out-of-scope organizations. A representative query is:

SELECT organization_id, business_group_id, name, date_from, date_to, internal_external_flag, location_id FROM per_organization_units WHERE business_group_id = :p_business_group_id AND NVL(date_to, SYSDATE) >= TRUNC(SYSDATE) ORDER BY name

Because the view already applies the HR_ORG class filter, consumers can rely on it returning only genuine HR organizations, and can join ORGANIZATION_ID to PER_ALL_PEOPLE_F or PER_ALL_ASSIGNMENTS_F to enrich HR extracts with organization names.