Search Results per_empdir_organizations




Overview
Explore in AI Chat

Overview

PER_EMPDIR_ORGANIZATIONS is an HR-owned table within the Oracle E-Business Suite Human Resources (PER) module. It stores organization-level directory information used by the Employee Directory and related self-service directory features in Oracle EBS 12.1.1 and 12.2.2. The table provides the organizational context — name, location, and representatives — that is displayed alongside employee records in directory searches and organizational hierarchies.

From a data-modeling perspective, the mined foreign key structure suggests a standalone classification under the Data Vault heuristic. That is, the table does not serve as a canonical hub, link, or satellite in a conventional Data Vault sense; it behaves as a source-qualified reference table. Any Data Vault implementation should treat it as a standalone reference/satellite-style source rather than a core hub, and should reconcile the ORIG_SYSTEM-qualified keys against the originating source system before integrating it into a warehouse model.

Key Information Stored

The table contains 42 physical columns. Its primary key is a composite business-key candidate: PER_EMPDIR_ORGANIZATIONS_PK (ORIG_SYSTEM_ID, ORIG_SYSTEM, LANGUAGE). Notably, there is no independent surrogate key column in the documented schema; the PK is composed entirely of business attributes.

Common Use Cases and Queries

Typical uses include building directory listings of organizations and their representatives, reporting on organization coverage by business group, and reconciling directory entries against the originating source system. A representative query joining to the source-system base table is:

  • Joining to HZ_ORIG_SYSTEMS_B on ORIG_SYSTEM = HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM and ORIG_SYSTEM_ID = HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_ID to resolve the originating system name.
  • Filtering by BUSINESS_GROUP_ID to enforce business-group access across multi-org implementations.
  • Selecting NAME plus REPRESENTATIVE1_ID … REPRESENTATIVE4_ID to produce directory cards, then resolving the representative IDs against PER_ALL_PEOPLE_F.
  • Partition-aware queries joining PARTITION_ID to JTF_FM_PARTITION_X_REQUEST.
  • Validation queries checking for rows where LANGUAGE does not match the session language, exposing missing translations.

Related Objects

  • HZ_ORIG_SYSTEMS_B — referenced via ORIG_SYSTEM_ID; provides the source-system definition and is a direct parent of the foreign key.
  • JTF_FM_PARTITION_X_REQUEST — referenced via PARTITION_ID; ties the row to a partition.
  • PER_ALL_PEOPLE_F — resolves the REPRESENTATIVE1_ID … REPRESENTATIVE4_ID person keys.
  • HR_LOCATIONS_ALL (or the HR location view) — resolves LOCATION_ID.
  • PER_BUSINESS_GROUPS — resolves BUSINESS_GROUP_ID.
  • FND_LANGUAGES — resolves LANGUAGE and SOURCE_LANG.
  • Employee Directory / Self-Service Directory views and concurrent programs that populate and read this table via the standard WHO and request columns.