Results for “hrfv_locations”

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

Overview

HRFV_LOCATIONS is a business view template owned by the APPS schema and delivered as part of the PER (Human Resources) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The view is generated from the flexfield view template architecture used by Oracle HRMS, and its primary purpose is to expose location records in a denormalized, business-friendly form suitable for flexfield-driven descriptive flexfield (DFF) and key flexfield reporting. The view joins location data to business group names, shipping locations, designated receivers, inventory organizations, and several flag columns derived from HR lookups, allowing downstream reports, Oracle Discoverer workbooks, and integration extracts to obtain location information without navigating the highly normalized HR_LOCATIONS_ALL structure directly.

Within the ETRM classification the object is documented as a VALID view in the APPS schema with a status of VALID, reinforcing that it is a supported read-only interface rather than a base table. Because the view embodies the flexfield view template, it is the layer through which user-defined descriptive flexfield segments on locations are surfaced for reporting and for the _DF:PER:HR_LOCATIONS:LOC flexfield context.

Underlying Base Objects

According to the documented view text and ETRM metadata, HRFV_LOCATIONS is defined over the following base objects:

• HR_LOCATIONS_ALL (synonym) — the primary base table supplying address, telephone, tax, style, inactive date, business group, inventory organization, designated receiver, and location identifiers.
• HR_LOCATIONS_ALL_TL (synonym) — the translation table supplying the language-dependent location code and description, joined twice (for the current language and, as LOC2T, for the ship-to location code).
• HR_ALL_ORGANIZATION_UNITS_TL (synonym) — joined twice, as BGRT for the business group name and as ORGT for the inventory organization name.
• PER_PEOPLE_X (view) — provides the designated receiver's full name.
• HR_BIS, HR_GENERAL, HR_PERSON_NAME, HR_SECURITY (packages) — supporting HRMS packages referenced by the generated view for security, name formatting, and business group context.

The joins use outer-join syntax on BUSINESS_GROUP_ID and on the language code, and enforce the current session language through USERENV('LANG'), ensuring that translated names and descriptions are returned in the user's language.

Key Columns

The view exposes the following significant columns, with particular relevance to the inventory_organization_id search term:

• INVENTORY_ORGANIZATION_ID — the identifier of the inventory organization associated with the location, sourced from HR_LOCATIONS_ALL. This is the key join column to ORG_ORGANIZATION_DEFINITIONS and to inventory reporting.
• INVENTORY_ORGANIZATION — the translated name of that inventory organization from HR_ALL_ORGANIZATION_UNITS_TL.
• BUSINESS_GROUP_ID / BUSINESS_GROUP_NAME — the owning business group and its translated name.
• LOCATION_ID, LOCATION_NAME, LOCATION_DESCRIPTION — the primary location identifier and its translated code and description.
• ADDRESS_LINE_1..3, CITY, REGION_1..3, COUNTRY, POSTAL_CODE — the full postal address.
• TELEPHONE_NUMBER_1..3 — contact telephone numbers.
• DEFAULT_TAX_CODE (TAX_NAME) and ADDRESS_STYLE (STYLE) — tax and formatting attributes.
• SHIP_TO_LOCATION / SHIP_TO_LOCATION_ID — the shipping location code and identifier.
• DESIGNATED_RECEIVER / DESIGNATED_RECEIVER_ID — the receiver's name and identifier.
• BILL_TO_SITE_FLAG, INTERNAL_SITE_FLAG, RECEIVING_SITE_FLAG, OFFICE_SITE_FLAG, SHIP_TO_LOCATION_FLAG — lookup-derived Yes/No flags describing the site's usage.
• INACTIVE_DATE — the date the location was inactivated.

Common Use Cases and Queries

The most frequent use of the view is reporting on locations and their associated inventory organizations, and providing a security-aware source for HR flexfield reporting. A typical query filtering on the inventory organization is:

SELECT location_id, location_name, city, country, inventory_organization_id, inventory_organization FROM apps.hrfv_locations WHERE inventory_organization_id IS NOT NULL ORDER BY inventory_organization;

To list active receiving sites for a business group:

SELECT location_name, city, receiving_site_flag, organization FROM ... WHERE receiving_site_flag = 'Yes' AND inactive_date IS NULL;

To obtain address and receiver details for shipping:

SELECT ship_to_location, address_line_1, city, postal_code, designated_receiver FROM apps.hrfv_locations WHERE location_id = :p_location_id;

Because the view is security-enabled through HR_SECURITY, results are automatically filtered by the user's HR security profile, making it suitable for both Discoverer-based reporting and custom concurrent program extracts that must respect HRMS data security.