Search Results hr_organization_units_v




Overview
Explore in AI Chat

Overview

HR_ORGANIZATION_UNITS_V is an Oracle E-Business Suite view owned by the APPS schema and is a component of the PER (Human Resources) product family. The ETRM metadata records its status as VALID in both Release 12.1.1 and 12.2.2, and describes its purpose succinctly as "used to support user interface." In practice, the view presents organization unit definitions — the internal and external organizations, business groups, and reporting units that form the backbone of the HR and Payroll organizational hierarchy — in a denormalized, user-friendly form suitable for forms, concurrent programs, and ad hoc reporting. It resolves the raw foreign-key identifiers held on the base organization table into descriptive lookup meanings and location address attributes, sparing developers and report authors the effort of joining the lookup and location tables themselves. Because it is a view rather than a table, it holds no data of its own and instead projects a consistent, join-resolved image of the underlying organization records at query time.

Underlying Base Objects

The documented view text defines HR_ORGANIZATION_UNITS_V over four principal objects. HR_ORGANIZATION_UNITS is the driving table, supplying the organization identifier, name, dates, type, internal/external flag, comments, internal address line, and the full set of descriptive flexfield (DFF) attribute columns. HR_LOCATIONS_NO_JOIN supplies the location attributes, including location code, address lines, regions, telephone numbers, postal code, town or city, and the LOC_INFORMATION13 through LOC_INFORMATION20 segments. Two instances of HR_LOOKUPS are joined to translate coded values: lookup type ORG_TYPE decodes the organization TYPE column, and lookup type INTL_EXTL decodes the INTERNAL_EXTERNAL_FLAG column. All three joins are outer joins, so organization rows are retained even when no matching lookup meaning or location exists. The wider ETRM metadata additionally lists HR_API, HR_GENERAL, and HR_SECURITY packages together with HR_LOCATIONS_ALL_V and HR_ORGANIZATION_UNITS as referenced objects, reflecting the view's integration with HR security profiles and its exposure through the standard HR location view.

Key Columns

  • ORGANIZATION_ID — Primary identifier of the organization unit, and the value used throughout HR, Payroll, and inventory-related modules as the organization key.
  • BUSINESS_GROUP_ID — Identifies the business group to which the organization belongs, establishing the legislative and security context.
  • NAME — The user-visible name of the organization unit.
  • TYPE and its lookup MEANING — The organization classification code and the corresponding decoded meaning from lookup type ORG_TYPE.
  • INTERNAL_EXTERNAL_FLAG and its lookup MEANING — Indicates whether the organization is internal or external, decoded through lookup type INTL_EXTL.
  • DATE_FROM / DATE_TO — Effective dating that governs when the organization unit is active.
  • LOCATION_ID and address columns — Location code, address lines, region, postal code, town or city, and telephone numbers sourced from the location definition.
  • ATTRIBUTE1 through ATTRIBUTE20 and ATTRIBUTE_CATEGORY — Descriptive flexfield columns available for customer-defined organization information.
  • Audit columns — REQUEST_ID, PROGRAM_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include reporting on active organization structures, validating organization identifiers during conversions, and driving LOV queries in custom forms. The following sample retrieves active internal organizations for a given business group:

  • SELECT organization_id, name, type, meaning internal_external FROM hr_organization_units_v WHERE business_group_id = :p_business_group_id AND internal_external_flag = 'Y' AND SYSDATE BETWEEN NVL(date_from, SYSDATE) AND NVL(date_to, SYSDATE + 1);
  • SELECT organization_id, name, town_or_city, postal_code FROM hr_organization_units_v WHERE location_id IS NOT NULL ORDER BY name;

Because the view is secured through HR security profiles, query results are constrained by the MO: Security Profile and MO: Business Group profile options of the session, which should be considered when the view is used in integrations or data extracts.