Search Results get_trn_in_fte

Overview

HRI_OLTP_VIEW_WRKFRC_MGRH is an Oracle EBS PL/SQL package owned by the APPS schema that belongs to the Oracle HR Intelligence (HRI) operational reporting layer. It supplies the workforce headcount and position-count computation logic used behind the "Manager Hierarchy" (MGRH) operational views that feed Oracle HRMS analytics and workforce management reporting. The package is classified as OTHER in the ETRM metadata, meaning it is not a public, supported business API but rather an internal calculation utility invoked by other reporting constructs.

The package exposes a set of scalar functions that return numeric workforce metrics for a given manager, evaluated as of an effective date and scoped to a worker type and a direct-reports-only flag. Its core purpose is to answer, for any supervisor, how many people and positions sit beneath them, and how the workforce size changed over a period due to people moving into or out of that organization.

Key Procedures and Functions

All twelve documented members are functions returning NUMBER; there are no procedures. The first group returns a point-in-time metric as of an effective date:

• GET_HDC — returns the headcount for the supervisor. This is the object the user searched for ("get_hdc").
• GET_FTE — returns full-time-equivalent workforce for the supervisor.
• GET_PASG_CNT — returns the primary assignment count.
• GET_ASG_CNT — returns the assignment count.

The second group returns period movement metrics across a from-date/to-date range, in two directions:

• GET_TRN_IN_HDC / GET_TRN_OUT_HDC — headcount transferred into or out of the organization.
• GET_TRN_IN_FTE / GET_TRN_OUT_FTE — FTE transferred in or out.
• GET_TRN_IN_PASG_CNT / GET_TRN_OUT_PASG_CNT — primary assignments transferred in or out.
• GET_TRN_IN_ASG_CNT / GET_TRN_OUT_ASG_CNT — assignments transferred in or out.

Each function accepts the supervisor person identifier, and either an effective date (point-in-time functions) or a date range (transfer functions), together with a worker type and a directs-only indicator that restricts the result to direct reports or includes the full reporting line.

Tables Accessed

The package reads from three documented tables through APPS synonyms:

• HRI_MB_WRKFC_EVT_CT — the workforce event collection table, providing the source rows for current headcount, FTE, and assignment measures.
• HRI_MDP_MGRH_TRANSFERS_CT — the manager-hierarchy transfers table, supplying the transfer-in and transfer-out movements used by the GET_TRN_IN_* and GET_TRN_OUT_* functions.
• HRI_MDS_WRKFC_MGRH_C01_CT — a manager-hierarchy workforce collection table used to resolve the reporting relationship between a supervisor and the workers beneath them.

Usage Notes

HRI_OLTP_VIEW_WRKFRC_MGRH is an internal dependency rather than a standalone interface. It is referenced by one other package, which drives its invocation, and its documented functions are typically exercised indirectly when the associated manager-hierarchy operational views are queried. Because results are date-driven and parameterized by worker type and directs-only scope, callers must supply a valid effective date or date range and expect NUMBER output suitable for direct aggregation. Custom code should treat it as an internal, unsupported object; it is not a substitute for the supported public HRMS APIs when performing data changes.