Search Results benefit_end_date




Overview
Explore in AI Chat

Overview

APPS.PAY_IE_BIK_OTHER_BENEFITS_V is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema. It exposes data related to Benefit-in-Kind (BIK) "other benefits" for Ireland (IE), as indicated by the IE country code and BIK designator in its name. The view is classified as VALID with internal view type, and is registered in FND Design Data under the application short name PAY, confirming it is a Payroll product object.

In EBS payroll processing, BIK represents taxable non-cash benefits such as company cars, employer-paid health insurance, and preferential loans. Irish payroll legislation requires these benefits to be reported per employee for taxation and statutory returns. This view consolidates the benefit periods, descriptions, and monetary values alongside employee and payroll identifiers, serving as a denormalized read surface for reporting, extract, and integration scenarios rather than transactional entry. The presence of PPS_NO (Personal Public Service Number, the Irish tax identifier) underscores its Ireland-specific regulatory purpose.

The ETRM metadata includes an Oracle Internal Use Only warning: Oracle does not support direct data access except from standard Oracle Applications programs. Custom development and reporting should therefore treat the view as a de facto interface while acknowledging the support boundary.

Underlying Base Objects

The view is defined over a wide set of Payroll, Human Resources, and lookup objects. Key documented dependencies include:

The view is documented as not referenced by any database object, meaning it is a terminal reporting object with no downstream database dependents. It is typically joined implicitly through security predicates from HR_SECURITY, restricting rows to the operating user's authorized business group and organization scope.

Key Columns

  • BENEFIT_START_DATE (VARCHAR2, 60) — the commencement date of the benefit; stored as character data, so it must be converted with TO_DATE prior to date arithmetic or comparison.
  • BENEFIT_END_DATE (VARCHAR2, 60) — the cessation date of the benefit, also character-formatted.
  • DESCRIPTION (VARCHAR2, 80) — textual description of the benefit or element.
  • VALUE (NUMBER) — the monetary or quantified value of the benefit.
  • PPS_NO (VARCHAR2, 30) — the Irish Personal Public Service Number, the primary tax reference for the employee.
  • SURNAME / FIRST_NAME (VARCHAR2, 150) — employee name components.
  • ASSIGNMENT_NUMBER, ASSIGNMENT_ID, PAYROLL_ID, CONSOLIDATION_SET_ID, ASSIGNMENT_SET_ID — identifiers linking the record to assignments, payrolls, and payroll processing sets.

Common Use Cases and Queries

Typical usage covers BIK reconciliation, statutory reporting extracts, and benefit audit. Because BENEFIT_START_DATE is character-typed, date filters should use TO_DATE. A representative query follows:

SELECT pps_no, surname, first_name, description, benefit_start_date, benefit_end_date, value FROM apps.pay_ie_bik_other_benefits_v WHERE TO_DATE(benefit_start_date,'DD-MON-YYYY') BETWEEN :p_start AND :p_end ORDER BY pps_no, benefit_start_date;

The view is well suited to feeding downstream BIK registers, validating benefit periods against payroll runs, and supporting Revenue Commissioner submissions. As with all APPS views containing HR security logic, results are automatically filtered by the session's security profile.