Search Results user_concat_person_type




Overview
Explore in AI Chat

Overview

APPS.HRFV_PHONES is a Business Intelligence System (BIS) view in Oracle E-Business Suite, owned by the APPS schema and registered under FND Design Data PER.HRFV_PHONES. It presents telephone details for persons recorded in the enterprise, combining phone records with person, person-type, and business-group attributes to support cross-functional reporting. Because it is a BIS view rather than a base table, it is intended for read-only consumption by reports, extracts, and integration layers that require phone numbers enriched with person identity and employment context.

The view is documented as VALID and is delivered identically in 12.1.1 and 12.2.2. Its naming prefix HRFV (Human Resources Forms View) indicates it is a seed view commonly used by Oracle HRMS forms and by custom BI Publisher or Discoverer solutions. It does not store data; all content is derived at runtime from the underlying PER_PHONES and PER_PEOPLE_X objects.

Underlying Base Objects

HRFV_PHONES is defined over the following documented objects: HRI_BPL_PERSON_TYPE (package), HR_ALL_ORGANIZATION_UNITS_TL (synonym), HR_BIS (package), HR_GENERAL (package), HR_PERSON_NAME (package), HR_SECURITY (package), PER_PEOPLE_X (view), PER_PERSON_TYPES (synonym), PER_PERSON_TYPES_TL (synonym), and PER_PHONES (synonym).

PER_PHONES supplies the phone number, phone type, and date range columns, along with the PHN_LAST_UPDATE_DATE WHO column. PER_PEOPLE_X supplies the effective-dated person record and contributes PEO_LAST_UPDATE_DATE. HR_PERSON_NAME and HR_GENERAL resolve the formatted PERSON_NAME, while HR_SECURITY enforces row-level access for the querying session. Person-type classification is resolved through HRI_BPL_PERSON_TYPE and PER_PERSON_TYPES_TL, and business group labels are resolved through HR_ALL_ORGANIZATION_UNITS_TL. HR_BIS provides additional business intelligence helper logic. Note that the dependency list references synonyms layered over the underlying PER base tables, so the view inherits any business-group and security filtering defined in those objects. Ordinary direct table privileges on PER_PHONES are not sufficient for querying HRFV_PHONES; the runtime security packages must execute with the appropriate context.

Key Columns

The view exposes identity, classification, and effective-dating columns relevant to phone reporting:

Common Use Cases and Queries

Typical scenarios include producing enterprise phone directories, feeding downstream HR extracts, and reporting headcount alongside contact details. Because the view respects HR security, results are restricted to records visible to the session's security profile.

Example — all phone numbers for current employees in a business group:

  • SELECT PERSON_NAME, EMPLOYEE_NUMBER, PHONE_TYPE, PHONE_NUMBER, USER_CONCAT_PERSON_TYPE
  • FROM APPS.HRFV_PHONES
  • WHERE CURRENT_EMPLOYEE_FLAG_CODE = 'Y'
  • AND BUSINESS_GROUP_ID = :p_business_group_id
  • AND TRUNC(SYSDATE) BETWEEN DATE_FROM AND DATE_TO_NN;

Example — phone numbers by concatenated person type:

  • SELECT USER_CONCAT_PERSON_TYPE, COUNT(DISTINCT PERSON_ID) PERSON_CT
  • FROM APPS.HRFV_PHONES
  • WHERE TRUNC(SYSDATE) BETWEEN DATE_FROM AND DATE_TO_NN
  • GROUP BY USER_CONCAT_PERSON_TYPE;

Always apply an effective-date predicate using DATE_FROM and DATE_TO_NN, and join on PERSON_ID where links to other HR views are required.