Search Results get_fte

Overview

HRI_OLTP_VIEW_WRKFRC_ORGH is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM "OTHER" API category. It belongs to the Oracle HR Intelligence (HRI) family of objects that support workforce analytics and organizational hierarchy reporting. The package exposes a set of scalar functions that return aggregated headcount, full-time equivalent (FTE), and assignment metrics for a given supervisor organization as of a specified effective date. In Oracle EBS 12.1.1 and 12.2.2, such packages typically back the Oracle HRMS/HRI dashboards, workforce intelligence views, and organization hierarchy reports used by HR administrators and line managers.

The package is declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking user rather than the definer. It is referenced by one other package in the ETRM metadata, indicating it is a lower-level building block consumed by higher-level reporting or collection packages.

Key Procedures and Functions

The package exposes twelve documented functions, which can be grouped into three categories.

• Current-state metrics — GET_HDC returns the headcount, GET_FTE returns the full-time equivalent total, GET_PASG_CNT returns the primary assignment count, and GET_ASG_CNT returns the total assignment count for the specified supervisor organization and effective date.
• Headcount and FTE transfer metrics — GET_TRN_IN_HDC and GET_TRN_OUT_HDC return the headcount transferred into and out of the organization over a date range. GET_TRN_IN_FTE and GET_TRN_OUT_FTE return the equivalent FTE transfer figures.
• Assignment transfer metrics — GET_TRN_IN_PASG_CNT and GET_TRN_OUT_PASG_CNT return primary assignment transfers in and out, while GET_TRN_IN_ASG_CNT and GET_TRN_OUT_ASG_CNT return total assignment transfers in and out over the specified period.

The user's search term "get_fte" corresponds directly to the GET_FTE function, which is the FTE analogue of the headcount function GET_HDC. All functions share a common filtering pattern based on supervisor organization, effective date, worker type, and a directs-only indicator, allowing callers to scope results to direct reports versus the full organization hierarchy.

Tables Accessed

The ETRM metadata documents three tables referenced through APPS synonyms:

• HRI_MB_WRKFC_EVT_CT — a workforce event collection table, used to derive transfer-in and transfer-out activity for headcount, FTE, and assignment counts.
• HRI_MDP_ORGH_TRANSFERS_CT — an organizational hierarchy transfers collection table, supporting movement metrics across the supervisor organization.
• HRI_MDS_WRKFC_ORGH_C01_CT — a workforce organization hierarchy collection table, providing the base organizational and workforce attributes used by the current-state and transfer calculations.

These are collection tables (denoted by the _CT suffix) that feed Oracle HR Intelligence reporting structures, consistent with the package's role as a view-oriented workforce analytics wrapper.

Usage Notes

HRI_OLTP_VIEW_WRKFRC_ORGH is typically invoked from HR Intelligence dashboards, organizational hierarchy reports, and custom workforce analytics code rather than from standard Oracle Forms. Because functions accept an effective date and a directs-only flag, callers should supply the appropriate date context and hierarchy scope to obtain meaningful results.

Given the AUTHID CURRENT_USER declaration, invoking users require direct access to the underlying APPS synonyms and collection tables; privilege gaps will surface as runtime errors. The package is best treated as a read-only reporting utility and should be called within the context of the HRI collection and refresh cycles that populate the referenced _CT tables.