Search Results per_empdir_locations




Overview
Explore in AI Chat

Overview

PER_EMPDIR_LOCATIONS is a Human Resources (PER) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The table stores the location records surfaced through the Oracle Employee Directory, the self-service facility that allows employees to search for colleagues and view published organizational and contact information. Each row represents a single location entry within the directory, carrying the address, telephone, timezone, and site-classification attributes that the directory displays against employees and organizations.

From a Data Vault modeling perspective, the metadata classifies this object as standalone using a heuristic mined from its foreign-key structure. This suggests it is best treated as an independent reference or lookup construct rather than as a hub, link, or satellite integrated into a broader integration-layer model. The table is populated and maintained primarily through directory synchronization processes that consolidate location data from the source HRMS and, in the eBusiness context, from Trading Community Architecture reference data.

Key Information Stored

The physical schema documents 35 columns. The most operationally significant are the following:

Common Use Cases and Queries

Typical usage centres on directory reporting and location validation. A common query joins the location to its timezone reference:

  • Retrieve active locations for a business group: SELECT orig_system, tax_name, town_or_city, country FROM per_empdir_locations WHERE business_group_id = :p_bg AND inactive_date IS NULL.
  • Resolve timezone detail: join TIMEZONE_ID to HZ_TIMEZONES to obtain descriptive timezone names for scheduling or reporting.
  • Feed the Employee Directory: extract address and telephone columns for locations referenced by employee directory records, filtering on OFFICE_SITE_FLAG.
  • Audit changes: query LAST_UPDATE_DATE and LAST_UPDATED_BY to reconcile directory content against upstream HRMS loads.
  • Decommission stale sites: identify rows where INACTIVE_DATE has passed for cleanup or archival.

Related Objects

Foreign-key and integration relationships documented for this table include the following:

  • HZ_ORIG_SYSTEMS_B — referenced through ORIG_SYSTEM_ID; defines the originating system registry for the directory location.
  • HZ_TIMEZONES — referenced through TIMEZONE_ID; supplies timezone definitions and offsets.
  • JTF_FM_PARTITION_X_REQUEST — referenced through PARTITION_ID; supports the framework partitioning and request mapping used by the directory components.
  • PER_EMPDIR_EMPLOYEES — the companion directory table whose employee rows reference location data maintained here.
  • HR_LOCATIONS_ALL — the core HR locations table that is the principal upstream source for directory location content.
  • PER_BUSINESS_GROUPS — supplies the BUSINESS_GROUP_ID context for every location row.
  • FND_FLEX_VALUES / FND_LOOKUPS — provide the validation values for country, style, and flag columns surfaced in the directory.