Results for “hr_h2pi_element_links_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The HR_H2PI_ELEMENT_LINKS_V view is an Oracle Human Resources (PER) object that exposes data required by the Oracle HR to Oracle Payroll Interface (H2PI) for element links. Element links determine which payroll elements are associated with specific payrolls, organizations, locations, pay bases, and other eligibility criteria, and they govern how an employee's assignment is matched to a given element during payroll processing. This view presents a filtered, H2PI-oriented projection of that link configuration so that downstream integrations and reporting tools can retrieve only those element links that correspond to valid HR-to-Payroll element types.

Within Oracle EBS 12.1.1 and 12.2.2, H2PI is used when payroll processing is performed in an external or third-party payroll system rather than native Oracle Payroll. The view therefore plays a reporting and integration role: it supplies the element link definitions that the interface extracts and forwards to the external payroll engine. Because it is an APPS-owned VIEW with VALID status, it can be queried directly in SQL*Plus, Oracle Reports, BI Publisher, or custom PL/SQL, and it is typically referenced by concurrent programs and extract logic rather than maintained by end users.

Underlying Base Objects

The documented view text shows that HR_H2PI_ELEMENT_LINKS_V is defined over two objects joined together:

• PAY_ELEMENT_LINKS_F (referenced as the synonym EL) — the core date-tracked table holding element link definitions, including the effective dating, payroll, element type, and eligibility attributes.
• HR_H2PI_ELEMENT_TYPES_V (referenced as ET) — the HR-to-Payroll Interface element types view, which restricts the result set to element types relevant to H2PI.

The join condition links the two on ELEMENT_TYPE_ID, and an additional predicate restricts the link's EFFECTIVE_START_DATE to fall between the element type's EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. This ensures that only currently valid combinations of element link and element type are returned, keeping the H2PI extract consistent with the effective-dated configuration of the element type itself.

Key Columns

The view exposes the following columns, each carrying forward the corresponding attribute from PAY_ELEMENT_LINKS_F:

• ELEMENT_LINK_ID — Primary identifier of the element link record; the unique key within the source table.
• BUSINESS_GROUP_ID — The business group that owns the element link, providing the legislative/enterprise context.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Date-tracked validity window of the link; used to qualify links that are in force on a given date.
• ELEMENT_TYPE_ID — The element type to which the link refers; the join key to HR_H2PI_ELEMENT_TYPES_V.
• PAYROLL_ID — The payroll to which the element is linked when the link is payroll-specific.
• COST_ALLOCATION_KEYFLEX_ID — Reference to the cost allocation key flexfield used when the element is to be costed.
• ORGANIZATION_ID, LOCATION_ID, PAY_BASIS_ID — Eligibility criteria restricting which assignments/organizations, locations, or pay bases the link applies to.
• LINK_TO_ALL_PAYROLLS_FLAG — The column the user searched for. It indicates whether the element link applies to all payrolls (commonly "Y") or is restricted to the specific PAYROLL_ID (commonly "N"). This flag is central to H2PI because it determines whether an element is distributed across every payroll in scope or only the one named.
• LAST_UPDATE_DATE — Audit column recording the most recent modification of the link, used for incremental extracts and change tracking.

Note that the documented column list uses LAST_UPD_DATE as a display heading for the LAST_UPDATE_DATE attribute.

Common Use Cases and Queries

Typical scenarios include validating element link configuration before an H2PI extract, reporting all links that apply to every payroll, and driving incremental downloads based on LAST_UPDATE_DATE.

• List links that apply to all payrolls:

  SELECT ELEMENT_LINK_ID, ELEMENT_TYPE_ID, PAYROLL_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
  FROM   APPS.HR_H2PI_ELEMENT_LINKS_V
  WHERE  LINK_TO_ALL_PAYROLLS_FLAG = 'Y';

• Retrieve links effective on a given date for a specific business group:

  SELECT ELEMENT_LINK_ID, ELEMENT_TYPE_ID, PAYROLL_ID
  FROM   APPS.HR_H2PI_ELEMENT_LINKS_V
  WHERE  BUSINESS_GROUP_ID = :p_business_group_id
  AND    :p_effective_date BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE, :p_effective_date);

• Incremental change extract for downstream H2PI processing:

  SELECT ELEMENT_LINK_ID, ELEMENT_TYPE_ID, PAYROLL_ID, LINK_TO_ALL_PAYROLLS_FLAG
  FROM   APPS.HR_H2PI_ELEMENT_LINKS_V
  WHERE  LAST_UPDATE_DATE >= :p_last_run_date;

These queries illustrate how the view supports both full and delta reporting of element link configuration for HR-to-Payroll Interface integration.