Search Results per_empdir_phones




Overview
Explore in AI Chat

Overview

PER_EMPDIR_PHONES is a Human Resources (PER) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores telephone number records associated with the Employee Directory, providing the contact phone data that surfaces in employee directory searches, self-service pages, and HR reporting. Each row represents one phone entry for a directory participant, keyed by an originating system and an originating system identifier.

From a Data Vault modeling perspective, the mined FK structure classifies this object heuristically as standalone — that is, it neither acts as a classic hub, link, nor satellite within the source FK topology. This classification is a modeling suggestion only and reflects the absence of outbound business-entity foreign keys beyond the two technical references noted below. In practice, PER_EMPDIR_PHONES behaves as a dependent descriptive entity, populated and maintained by concurrent programs that synchronize directory phone data from source systems.

Key Information Stored

The table contains 20 documented columns that fall into four functional groups: business keys, contact attributes, program/audit metadata, and partitioning controls.

The surrogate primary key is the composite (ORIG_SYSTEM_ID, ORIG_SYSTEM) exposed through PER_EMPDIR_PHONES_PK; no independent single-column surrogate is documented.

Common Use Cases and Queries

Typical uses include retrieving the current phone list for a directory participant, auditing stale or expired numbers, and reconciling directory loads by concurrent request. A common pattern restricts results to active rows and joins to the originating system registry:

  • Active phones for a parent entity: SELECT phone_type, phone_number FROM per_empdir_phones WHERE parent_id = :id AND parent_table = :tbl AND (date_to IS NULL OR date_to > SYSDATE).
  • Load reconciliation by request: filter on REQUEST_ID or PARTITION_ID to verify which rows a specific concurrent program instance inserted or updated.
  • Source system validation: join ORIG_SYSTEM_ID to HZ_ORIG_SYSTEMS_B to confirm the originating application is still registered.
  • Change tracking: compare LAST_UPDATE_DATE and PROGRAM_UPDATE_DATE to detect rows modified outside the expected program run.

Related Objects

  • HZ_ORIG_SYSTEMS_B — referenced via PER_EMPDIR_PHONES.ORIG_SYSTEM_ID; the registry of originating systems that own directory records.
  • JTF_FM_PARTITION_X_REQUEST — referenced via PER_EMPDIR_PHONES.PARTITION_ID; maps partition identifiers to concurrent request runs.
  • PER_EMPDIR_PHONES_PK — the unique index enforcing the ORIG_SYSTEM_ID and ORIG_SYSTEM business key.
  • Employee directory base entities referenced polymorphically through PARENT_ID and PARENT_TABLE, including the person and assignment records surfaced in the directory.
  • Concurrent programs identified by PROGRAM_APPLICATION_ID and PROGRAM_ID in FND_CONCURRENT_PROGRAMS, which populate and maintain this table.