Results for “get_nearest_parent”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.HRI_EDW_DIM_PERSON package is a helper package within the Oracle E-Business Suite Human Resources Intelligence / Enterprise Data Warehouse (HRI/EDW) layer. It supplies person-level dimensional classification and hierarchy resolution logic used to populate and support the person dimension in the EBS reporting and analytics schema. Its principal business role is to answer a set of recurring questions about an employee or resource as that person is processed into the warehouse: which supervisor or parent node sits above them in the reporting hierarchy, and whether that person participates in a specific operational role such as buyer, planner, or sales representative. By encapsulating these determinations in a single package, the HRI/EDW extraction and dimension-building routines avoid duplicating the lookup logic against the transactional applications tables.
The package is owned by APPS and is classified under ETRM as OTHER, meaning it is not a public, supported business API but an internal utility. It is referenced by two other packages, indicating that it is called from within the EBS data warehouse build rather than directly by end users.
Key Procedures and Functions
The documented interface consists of four functions, each returning a value that supports person-dimension enrichment. Parameter lists are not fully published; the descriptions below reflect the documented signatures.
- GET_NEAREST_PARENT — Accepts a person identifier and returns the identifier of that person's nearest parent in the supervisory hierarchy. This resolves the immediate reporting relationship used to build hierarchical roll-ups in the person dimension.
- IS_A_BUYER — Accepts a person identifier and returns a
VARCHAR2flag indicating whether the person is a purchasing buyer. The result supports role-based segmentation of the person dimension. - IS_A_PLANNER — Accepts a person identifier and returns a
VARCHAR2flag indicating whether the person acts as a materials planner. - IS_A_SALES_REP — Accepts a person identifier and returns a
VARCHAR2flag indicating whether the person is a sales representative.
All four functions return scalar values and are read-only with respect to business data; they perform classification lookups rather than updates.
Tables Accessed
The package reads from four documented sources through APPS synonyms:
- HRI_SUPV_HRCHY_SUMMARY — The summarized supervisory hierarchy, used by
GET_NEAREST_PARENTto establish parent-child relationships between persons. - PO_AGENTS — The purchasing agents table, used by
IS_A_BUYERto determine buyer status. - MTL_PLANNERS — The inventory planners table, used by
IS_A_PLANNERto determine planner status. - RA_SALESREPS_ALL — The receivables sales representatives table, used by
IS_A_SALES_REPto determine sales representative status.
These reads confirm the package's role as a cross-application classifier spanning HR, Purchasing, Inventory, and Receivables data.
Usage Notes
HRI_EDW_DIM_PERSON is an internal utility invoked by the HRI/EDW dimension-loading packages, as evidenced by its two inbound package references. It is not intended for direct invocation from Oracle Forms or concurrent programs, and it exposes no user-facing interface. Custom reporting or extension code that needs the same classifications may call these functions, but doing so couples the calling code to an internal, unsupported object whose behavior is tied to the EDW schema version. In 12.1.1 and 12.2.2 environments, the package should be treated as read-only supporting infrastructure; changes to its internal logic are governed by the EBS patch cycle and should not be made independently.