Search Results hr_fr_pension_groups_v




Overview
Explore in AI Chat

Overview

The view APPS.HR_FR_PENSION_GROUPS_V is a Human Resources (PER) reporting object in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes a filtered, denormalized list of organization units that have been classified as French pension groups. In the Oracle HR data model, organizations can carry multiple classifications through the HR_ORGANIZATION_INFORMATION table, where the combination of an information context and typed attributes determines the classification type. This view isolates those organizations whose classification context is CLASS and whose first attribute (ORG_INFORMATION1) equals FR_PENSION_GROUP, surfacing the pension-group-relevant address, location, and descriptive attributes in a single queryable structure. It functions primarily as a reporting and integration convenience view: rather than joining organization units, organization information, organization name translations, and locations manually, developers and report authors select directly from this view. As a database view it stores no data of its own; the ETRM metadata lists it as VALID under the APPS schema.

Underlying Base Objects

The view text joins four documented base objects. HR_ALL_ORGANIZATION_UNITS supplies the core organization unit rows, including organization identifier, business group, date bounds, address line, location, and comments. The same table is aliased a second time for the translated name. HR_ALL_ORGANIZATION_UNITS_TL provides the language-specific NAME value; the join is constrained by USERENV('LANG') so that only the name row for the caller's session language is returned. HR_ORGANIZATION_INFORMATION is the classification table; the view restricts it to the CLASS context, FR_PENSION_GROUP in attribute one, and ORG_INFORMATION2 = 'Y'. HR_LOCATIONS (documented in ETRM as a view) is joined with an outer join ((+)) on LOCATION_ID, so an organization without a defined location still appears. The metadata also lists HR_GENERAL (sample form-API package used during maintenance) and synonyms for the two organization tables.

Key Columns

  • ORGANIZATION_ID — Primary identifier of the pension group organization unit.
  • BUSINESS_GROUP_ID — Business group owning the organization; the standard security and partitioning key.
  • NAME — Language-specific organization name from the translated table.
  • DATE_FROM / DATE_TO — Effective start and end dates of the organization unit.
  • INTERNAL_ADDRESS_LINE — Internal mail or address line for the organization.
  • LOCATION_ID / LOCATION_CODE — Location identifier and its code; LOCATION_CODE may be null due to the outer join.
  • COMMENTS — Free-text comments on the organization unit.
  • ENABLED — Derived from ORG_INFORMATION2 = 'Y', indicating the pension group classification is active or enabled.

Common Use Cases and Queries

Typical consumption includes listing enabled French pension groups for a business group, feeding payroll or statutory reporting extracts, and validating organization classifications during implementation. The following sample returns the effective, enabled pension groups for one business group:

  • SELECT organization_id, name, date_from, date_to, location_code
  • FROM apps.hr_fr_pension_groups_v
  • WHERE business_group_id = :p_business_group_id
  • AND enabled = 'Y'
  • AND SYSDATE BETWEEN NVL(date_from, SYSDATE) AND NVL(date_to, SYSDATE + 1);

Because the view depends on the session language for the NAME column, results may vary by login locale. Callers should honor organization security by filtering on BUSINESS_GROUP_ID or by using standard HR security APIs.