Search Results hrfv_addresses




Overview
Explore in AI Chat

Overview

HRFV_ADDRESSES is a business view template owned by the APPS schema in Oracle E-Business Suite, delivered under the PER (Human Resources) product family. As documented, it is the "business view template from which the flexfield view is generated" — meaning it serves as the descriptive definition layer that Oracle's flexfield view generation utilities use to produce the corresponding run-time flexfield (descriptive flexfield, or DFF) view for person addresses. Its status in ETRM 12.2.2 is VALID, and it is present in both 12.1.1 and 12.2.2 environments.

The view presents person address information in a flattened, business-friendly layout. Rather than requiring report authors or integration developers to join HR person, person type, address, and organization tables manually, HRFV_ADDRESSES exposes a single row per current, effective address record with decoded, human-readable values. It is intended primarily as a reporting and integration surface — for example, as a data source for Oracle Reports, BI Publisher, Oracle Discoverer workbooks, or interfaces that extract employee and applicant addresses.

A distinguishing characteristic is the inline literal column '_DF:PER:PER_ADDRESSES:ADDR', which identifies the underlying descriptive flexfield context (PER_ADDRESSES with the ADDR alias). This confirms the view's role as a DFF template rather than a purely transactional reporting view.

Underlying Base Objects

HRFV_ADDRESSES is defined in the APPS schema over the following documented base objects:

The joins are anchored on PERSON_ID and BUSINESS_GROUP_ID, with language-based joins on the _TL tables using USERENV('LANG').

Key Columns

Common Use Cases and Queries

Typical uses include employee directory extracts, address verification reports, applicant address listings, and DFF-driven integrations. Because the view is created WITH READ ONLY, it cannot be used for DML.

A simple extract of current primary addresses for active employees:

SELECT person_name, employee_number, address_style, address_line1,
       city, region_1, postal_code, country, telephone_number_1
FROM   apps.hrfv_addresses
WHERE  current_employee_flag = 'Yes'
AND    primary_flag = 'Yes'
ORDER BY person_name;

Listing all addresses by business group, useful for multi-organization reporting:

SELECT business_group_name, person_name, person_type,
       address_type, addr_date_from, addr_date_to
FROM   apps.hrfv_addresses
WHERE  business_group_id = :p_business_group_id
ORDER BY person_name, addr_date_from DESC;

Because business group security is enforced via HR_BIS.GET_SEC_PROFILE_BG_ID in the view definition, results are automatically restricted to the business groups permitted by the running user's security profile — an important consideration when scheduling concurrent reports. Report authors should also note that the view returns only currently effective addresses due to the SYSDATE date filter.