Results for “is_a_planner”

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 VARCHAR2 flag 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 VARCHAR2 flag indicating whether the person acts as a materials planner.
  • IS_A_SALES_REP — Accepts a person identifier and returns a VARCHAR2 flag 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_PARENT to establish parent-child relationships between persons.
  • PO_AGENTS — The purchasing agents table, used by IS_A_BUYER to determine buyer status.
  • MTL_PLANNERS — The inventory planners table, used by IS_A_PLANNER to determine planner status.
  • RA_SALESREPS_ALL — The receivables sales representatives table, used by IS_A_SALES_REP to 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.