Results for “exclusion_reason”

40 results




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

Overview

HRFV_US_PERSONAL_DETAILS is an APPS-owned, VALID business view template within the PER (Human Resources) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. As its description states, it is the "business view template from which the flexfield view is generated," meaning it defines the column projection, joins, and descriptive flexfield (DFF) context that Oracle uses to materialize a delivered flexfield view exposing United States person-level personal details. Because the view filters on BGR.LEGISLATION_CODE = 'US', it is scoped strictly to US business groups. The view is exposed with the WITH READ ONLY clause, so it supports query and reporting workloads only and cannot be used for DML. It is intended for reporting, extracts, and integration scenarios where a flat, denormalized projection of personal information is required, rather than as a transactional entry point.

Underlying Base Objects

The view is defined over a small set of base objects and packages documented in ETRM 12.2.2:

The security predicate PEO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PEO.BUSINESS_GROUP_ID) ensures data is filtered according to the user's security profile.

Key Columns

Common Use Cases and Queries

Typical scenarios include US headcount and personal-detail reporting, I-9 and visa compliance extracts, and integration feeds requiring decoded DFF values. A simple query retrieving middle names and related attributes follows:

  • SELECT PERSON_ID, EMPLOYEE_NUMBER, LAST_NAME, FIRST_NAME, MIDDLE_NAMES FROM APPS.HRFV_US_PERSONAL_DETAILS WHERE MIDDLE_NAMES IS NOT NULL;
  • SELECT BUSINESS_GROUP_NAME, PERSON_NAME, MIDDLE_NAMES, SOCIAL_SECURITY_NUMBER FROM APPS.HRFV_US_PERSONAL_DETAILS WHERE EMPLOYEE_NUMBER = :emp_num;
  • SELECT PERSON_NAME, I9, I9_EXPIRY_DATE, VISA_TYPE FROM APPS.HRFV_US_PERSONAL_DETAILS WHERE I9 = 'Y' AND I9_EXPIRY_DATE < SYSDATE + 30;

Because the view is read-only and security-filtered, queries automatically inherit the caller's business group security profile, making it suitable for both ad hoc reporting and scheduled concurrent program extracts.