Search Results compute_reports




Overview
Explore in AI Chat

Overview

APPS.PER_EMPDIR_SS is an Oracle E-Business Suite server-side PL/SQL package that supports the Employee Directory (EmpDir) self-service feature set. In Oracle EBS 12.1.1 and 12.2.2, the Employee Directory provides a searchable, web-based view of an organization's workforce, exposing employee job information, photographs, contact details, and organizational placement. PER_EMPDIR_SS serves as the processing and staging engine behind that experience: it is responsible for consolidating HR data into the denormalized PER_EMPDIR_* tables that the directory user interface queries at runtime, and for maintaining those tables as source HR records change.

The package is classified under ETRM as an OTHER API rather than a public, supported business API, which indicates it is intended for internal consumption by the Employee Directory product code rather than for general customer extension. The source header (peredrcp.pkh, version 120.2) confirms its role as a compiled package specification, with global constants controlling commit batching (g_commit_size of 5000), debug and trace flags, and session context captured from FND_GLOBAL such as request ID, program application ID, program ID, user ID, and login ID. Bulk collection types sized from VARCHAR2(10) through VARCHAR2(2000), together with a record type containing job, location, organization, and position definition identifiers, reflect a bulk-processing design suited to high-volume directory refreshes.

Key Procedures and Functions

  • MAIN — Entry point that orchestrates the directory staging and refresh cycle, coordinating the supporting routines within the package.
  • SWAP — Performs the exchange of staged directory data into the live PER_EMPDIR_* tables, allowing a newly built snapshot to replace the existing published directory content.
  • COMPUTE_REPORTS — Derives and assembles the reporting or summary structures consumed by the Employee Directory presentation layer.
  • WRITE_LOG — Records diagnostic and processing messages, respecting the package-level debug and trace flags.
  • GET_TIME — Returns the current processing date/time used in directory maintenance operations.
  • GET_TIMEZONE_ID — Resolves the numeric time zone identifier applied to directory records.
  • GET_TIMEZONE_CODE — Resolves the time zone code value corresponding to a directory record's locale or location.

Parameter lists are intentionally omitted; these routines are internal and their signatures are not part of the documented public interface.

Tables Accessed

The package operates across two data domains. Source HR tables include HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL, HR_LOCATIONS_ALL_TL, and HR_ORGANIZATION_INFORMATION, which supply organizational unit, location, and translated location data. Person and image sources include PER_IMAGES and PER_EMPDIR_PEOPLE, PER_EMPDIR_ASSIGNMENTS, PER_EMPDIR_JOBS, PER_EMPDIR_POSITIONS, PER_EMPDIR_PHONES, and PER_EMPDIR_ORGANIZATIONS, which carry the denormalized employee, assignment, job, position, phone, and organization records that constitute the directory. The PER_EMPDIR_IMAGES and PER_EMPDIR_IMAGES_S pairing indicates use of a dated/audit table alongside the base images table, and PER_EMPDIR_LOCATIONS with PER_EMPDIR_LOCATIONS_TL provides the location and translated location entries rendered in the directory. Writes are concentrated in the PER_EMPDIR_* tables; reads draw from the HR_* tables and PER_IMAGES.

Usage Notes

PER_EMPDIR_SS is normally executed indirectly rather than called by name from custom code. In 12.1.1 and 12.2.2 it is invoked in three principal ways: through the Employee Directory self-service pages in the Oracle Applications Framework (OAF) layer; through concurrent programs that periodically rebuild or refresh the directory tables, where g_request_id and the g_commit_size batching constant govern processing; and internally by the seven other packages documented as referencing it. Because the package is classified as OTHER, direct invocation from customer extensions is not supported and version upgrades may alter behavior without notice. Where customization is required, the supported approach is to consume the PER_EMPDIR_* tables and the Employee Directory public views rather than to call PER_EMPDIR_SS routines directly. Administrators should also ensure that concurrent refresh jobs run during off-peak windows, since the SWAP operation replaces the published directory snapshot and the bulk commit size of 5000 rows implies substantial transactional volume.