Search Results hrfv_transfers_in




Overview
Explore in AI Chat

Overview

HRFV_TRANSFERS_IN is an APPS-owned business view template in the PER (Human Resources) product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It is a flexfield view generated from the Oracle HRMS Business Intelligence System (BIS) or "flexfield view" framework, in which an underlying business view template is materialized into a runtime view that exposes decoded, user-friendly HR attributes for reporting. Because it is a template-driven object, the definition is derived from metadata rather than hand-written SQL, which allows the HR BIS layer to standardize naming and decoding across releases.

The view presents current assignment records that represent employee transfers into an organization. It joins the assignment, person, person type, organization, grade, job, position, and location entities, and exposes both the destination organization (ORGANIZATION_NAME) and the prior or source organization (OLD_ORGANIZATION_NAME). It is primarily consumed by Oracle HRMS reporting, Oracle Daily Business Intelligence for HR, and custom extracts, rather than by transactional forms. A frequent user search, old_organization_name, reflects a common reporting need: identifying where an employee transferred from, particularly for headcount movement, transfer analysis, and organizational realignment reporting.

Underlying Base Objects

The view is defined over a set of core PER and HR synonyms, views, and packages documented in the ETRM 12.2.2 metadata:

The joins are effective-dated: PAF.EFFECTIVE_START_DATE must fall between the person's and person type usage effective ranges, ensuring the returned assignment, person, and person type rows are contemporaneous. The assignment is restricted to system person type 'EMP' and to assignment status types where PER_SYSTEM_STATUS is not 'TERM_ASSIGN', so terminated assignments are excluded. The view is named "_IN" to denote that it returns transfers into an organization, contrasting with its sibling template HRFV_TRANSFERS_OUT.

Key Columns

Common Use Cases and Queries

Typical uses include transfer movement reports, organization realignment audits, and feeds into HR data warehouses. A representative query lists transfers into a target organization during a period, using OLD_ORGANIZATION_NAME to show the origin:

SELECT person_name,
       employee_number,
       old_organization_name,
       organization_name,
       transfer_date,
       assignment_number
FROM   apps.hrfv_transfers_in
WHERE  organization_name = 'Vision Operations'
AND    transfer_date BETWEEN to_date('01-JAN-2024','DD-MON-YYYY')
                         AND to_date('31-DEC-2024','DD-MON-YYYY');

For origin-based analysis, report authors filter or group on old_organization_name to count movements from each source organization, which directly supports the "old_organization_name" search intent. A further use case joins the view back to HR_ALL_ORGANIZATION_UNITS_TL on business group to enrich regional or hierarchy context. Because HR_SECURITY is referenced, the view applies row-level security so users see only the people and organizations their security profile permits. In release 12.2.2 the definition is unchanged in functional intent, and the object remains an APPS synonym resolving to the generated flexfield view.