Search Results edw_hr_person_pkg




Overview
Explore in AI Chat

Overview

EDW_HR_PERSON_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Enterprise Data Warehouse (EDW) family of database objects used by Oracle's embedded business intelligence and operational reporting infrastructure. The package provides a set of reusable lookup functions that resolve a person identifier into context-specific role attributes — buyer, planner, sales representative — which are required by the EDW materialized views and fact collection views that stage human resources and procurement data.

In the documented ETRM classification, the package is registered with an API classification of OTHER, meaning it is not a public, supported business API. It exists primarily as an internal helper for the EDW view layer rather than as a callable integration point. Its status is VALID in the APPS schema, confirming that the package specification and body compile cleanly and that all dependent objects resolve at runtime.

Key Procedures and Functions

The ETRM metadata documents six procedures or functions within this package. Each appears designed to answer a specific business question about a person's role in the enterprise:

  • REGULAR_EMPLOYEE_FK — Resolves whether a given person qualifies as a regular employee and returns the corresponding foreign key reference used by downstream EDW entities.
  • PLANNER_FK — Returns the planner foreign key associated with a person, linking the individual to the inventory planning role.
  • SALES_REP_FK — Returns the sales representative foreign key for a person, enabling reporting on sales-related activity.
  • BUYER_FLAG — Returns a flag indicating whether the person holds the buyer role in procurement.
  • PLANNER_FLAG — Returns a flag indicating whether the person acts as a planner.
  • SALES_REP_FLAG — Returns a flag indicating whether the person acts as a sales representative.

The FK-suffixed functions return identifier values suitable for joins, while the FLAG-suffixed functions return boolean-style indicators suitable for conditional aggregation or filtering in EDW queries.

Tables Accessed

The package reads from four documented tables, accessed through APPS synonyms:

  • EDW_LOCAL_INSTANCE — Provides local instance context, allowing the package to behave correctly across multiple operating units or installations.
  • MTL_PLANNERS — The inventory planner master, used to confirm planner assignment for a person.
  • PO_AGENTS — The purchasing agent definition, used to determine buyer status.
  • RA_SALESREPS_ALL — The receivables sales representative table, used to resolve sales representative identity.

Usage Notes

EDW_HR_PERSON_PKG is not a standalone module. It is referenced by eight other packages and is consumed by a family of EDW fact collection views (FCVs) in the procurement domain, including POABV_EDW_AGREEMENT_LINES_FCV, POABV_EDW_CONTRACT_AGRMNTS_FCV, POABV_EDW_RECEIVING_TXN_FCV, POABV_EDW_SUPPLIER_PERFORM_FCV, and their POA_-prefixed counterparts. These views use the package's flag and foreign key functions to enrich transaction facts with role-based attribution at load time. Customizations should not modify the package directly; it is Oracle-proprietary, confidential code subject to legal notices. Developers integrating with EDW reporting should treat these functions as internal contract elements and avoid direct calls in custom code.