Search Results edw_hr_prsn_typ_pkg




Overview
Explore in AI Chat

Overview

EDW_HR_PRSN_TYP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an "OTHER" API type. The package is part of the Oracle HRMS Enterprise Data Warehouse (EDW) extraction layer, which supplies conformed dimensional data to Oracle Business Intelligence and related HR analytics products. Its business purpose is to resolve person type classification values used across the HR workforce subject areas, converting transactional Human Resources person-type definitions into the surrogate key representation required by the EDW star schemas.

The object is documented as VALID across Oracle EBS 12.1.1 and 12.2.2, confirming it remains a supported internal component in both release trains. It is not a public, customer-facing API; Oracle does not expose it for general use, and it is maintained solely to support the delivered EDW collection programs.

Key Procedures and Functions

  • PERSON_TYPE_FK — The single documented procedure/function within the package. Its purpose is to derive the person type foreign key mapping used by the EDW HR subject areas. Rather than returning source system person type identifiers directly, it resolves the appropriate warehouse key so that fact tables and aggregate views (activity, composition, recruitment, and separation) can join consistently to the person-type dimension.

The ETRM metadata records only one documented callable unit, and no parameter lists are published. Any invocation should therefore be treated as internal to the EDW packages rather than as a documented public interface.

Tables Accessed

  • EDW_LOCAL_INSTANCE — Referenced through an APPS synonym, this table identifies the local source instance and its EDW configuration context. The package reads it to establish which instance's person type data is being processed, ensuring key resolution is scoped correctly when multiple source instances feed the same warehouse.

Dependency metadata additionally shows a reference to the SYS.STANDARD package, which is a normal PL/SQL runtime dependency rather than a business table. No other base or staging tables are documented against this package.

Usage Notes

EDW_HR_PRSN_TYP_PKG is an internal building block of the HR EDW load path. It is referenced by eight other packages, all of which are EDW HR workforce components:

These are invoked during the scheduled ETL/collection run that populates the HR EDW fact collection views. Administrators and developers should not call EDW_HR_PRSN_TYP_PKG directly from forms, concurrent programs, or custom code. Because the ETRM entry documents no public parameters and Oracle labels the object "OTHER," any dependency on it in customization carries upgrade risk, particularly between 12.1.1 and 12.2.2. When troubleshooting missing or misaligned person type keys in HR analytics, the correct approach is to trace the collection run through the referencing FCV packages and verify EDW_LOCAL_INSTANCE configuration, rather than modifying this package.