Results for “recruitment_activity_name”

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

Overview

HRFV_REC_ACT_BY_VACANCIES is an APPS-owned business view template in the PER (Human Resources) product module of Oracle E-Business Suite, documented as VALID under ETRM 12.2.2. Its description identifies it as a "business view template from which the flexfield view is generated," placing it within the family of HR Flexible Validation (HRFV) views that expose human resources and recruitment data in a denormalized, report-friendly form. The view presents recruitment activities in relation to the vacancies against which they are undertaken, resolving recruitment activity records, vacancy records, and the owning business group into a single flattened result set. Because it joins descriptive name columns alongside the underlying surrogate identifiers, it is well suited for operational reporting, concurrent program data sources, and integration extracts that require human-readable recruitment activity and vacancy labels together with their primary keys.

Underlying Base Objects

The documented base objects are PER_RECRUITMENT_ACTIVITIES, PER_RECRUITMENT_ACTIVITY_FOR, PER_VACANCIES, and HR_ALL_ORGANIZATION_UNITS_TL, together with the HR_BIS, HR_GENERAL, and HR_SECURITY packages. The view is defined by a SELECT over these objects with outer joins between PER_RECRUITMENT_ACTIVITIES and PER_RECRUITMENT_ACTIVITY_FOR, and between PER_RECRUITMENT_ACTIVITY_FOR and PER_VACANCIES, so that recruitment activities are retained even when no vacancy association or vacancy record exists. The business group name is sourced from HR_ALL_ORGANIZATION_UNITS_TL, joined on PRA.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID, and the language predicate BGRT.LANGUAGE = USERENV('LANG') ensures that the translated name is returned in the session language. Business group level security is enforced through the predicate PRA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PRA.BUSINESS_GROUP_ID), which restricts rows to the security profile context of the current user when one is set.

Key Columns

• BUSINESS_GROUP_NAME – Translated name of the business group organization unit that owns the recruitment activity.
• RECRUITMENT_ACTIVITY_NAME – Name of the recruitment activity from PER_RECRUITMENT_ACTIVITIES.
• VACANCY_NAME – Name of the associated vacancy from PER_VACANCIES.
• BUSINESS_GROUP_ID – Identifier of the owning business group, usable as a foreign key and security discriminator.
• RECRUITMENT_ACTIVITY_ID – Primary identifier of the recruitment activity.
• VACANCY_ID – Primary identifier of the vacancy, null where no vacancy is associated.

Common Use Cases and Queries

Typical scenarios include listing the activities linked to each vacancy for recruitment pipeline analysis, validating activity-to-vacancy mappings, and populating extracts or reports where descriptive names are required alongside IDs. The view is read-only (WITH READ ONLY), so it should be used strictly as a query source.

• Enumerate activities for a specific vacancy:

  SELECT RECRUITMENT_ACTIVITY_NAME, VACANCY_NAME
  FROM   APPS.HRFV_REC_ACT_BY_VACANCIES
  WHERE  VACANCY_ID = :p_vacancy_id;

• Produce a business-group-scoped listing of activities and vacancies:

  SELECT BUSINESS_GROUP_NAME, RECRUITMENT_ACTIVITY_NAME, VACANCY_NAME
  FROM   APPS.HRFV_REC_ACT_BY_VACANCIES
  WHERE  BUSINESS_GROUP_ID = :p_bg_id
  ORDER  BY RECRUITMENT_ACTIVITY_NAME;

• Detect recruitment activities with no associated vacancy, exploiting the outer join semantics:

  SELECT RECRUITMENT_ACTIVITY_NAME
  FROM   APPS.HRFV_REC_ACT_BY_VACANCIES
  WHERE  VACANCY_ID IS NULL;

All queries execute under the security profile of the connected user; results are therefore implicitly filtered by the HR business group security model.