Results for “hrfv_grades”

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

Overview

HRFV_GRADES is an APPS-owned, VALID business view in the PER (Human Resources) product of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. The ETRM metadata describes it as a "Business view template from which the flexfield view is generated." This designation indicates that HRFV_GRADES is not intended as an end-user reporting entity in its own right, but rather serves as the source template for Oracle's Flexfield Views feature. Oracle uses such templates to generate runtime views (commonly the HRFV_* family, e.g. HRFV_GRADES_KFV and related descriptive-flexfield views) that expose key and descriptive flexfield segments as discrete columns. The view therefore plays an infrastructure role in reporting and integration: it consolidates grade header data from the base tables and joins descriptive flexfield context information, enabling flexfield-aware queries against grade definitions. Users searching for "grade_definition_id" will find this column exposed by HRFV_GRADES, reflecting its lineage from PER_GRADE_DEFINITIONS.

Underlying Base Objects

The documented base objects referenced by HRFV_GRADES are:

• PER_GRADES (SYNONYM) — the core grade table holding business group, grade identifier, dates, sequence, and comments.
• PER_GRADE_DEFINITIONS (SYNONYM) — the grade definition table providing GRADE_DEFINITION_ID and the enabled flag filter.
• HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM) — the translated organization unit table supplying the business group name.
• HR_BIS (PACKAGE) — the Business Intelligence/security package invoked through HR_BIS.GET_SEC_PROFILE_BG_ID for business group security profile filtering.

The view text joins PER_GRADE_DEFINITIONS to PER_GRADES on GRADE_DEFINITION_ID, restricting to GRADE_DEFINITIONS records where ENABLED_FLAG = 'Y'. It joins PER_GRADES.BUSINESS_GROUP_ID to HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID at the user's session language via USERENV('LANG'), and applies business group security through NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, GRD.BUSINESS_GROUP_ID). The view is defined WITH READ ONLY, guaranteeing no DML is possible through it.

Key Columns

• GRADE_DEFINITION_ID — the identifier of the grade definition, sourced from PER_GRADE_DEFINITIONS; the join key between grade definitions and grades and the term most frequently searched by users.
• GRADE_ID — the specific grade record identifier from PER_GRADES.
• BUSINESS_GROUP_ID — the business group (organization) to which the grade belongs; also the security-filtered column.
• BUSINESS_GROUP_NAME — the translated name of the business group, from HR_ALL_ORGANIZATION_UNITS_TL.
• DATE_FROM / DATE_TO — the effective start and end dates of the grade.
• COMMENTS — free-text comments on the grade.
• SEQUENCE — the ordering sequence of the grade.
• "_KF:PER:GRD:GDEF" and "_DF" — flexfield placeholder columns used by the template mechanism to generate key and descriptive flexfield segment columns in the derived runtime views.

Common Use Cases and Queries

Typical scenarios include resolving a GRADE_DEFINITION_ID to its grade attributes, reporting active grades within a business group, and validating grade data during HR or payroll interface troubleshooting. Because the view is security-filtered through HR_BIS and READ ONLY, it is safe for ad hoc reporting.

Example: list enabled grades for the current business group with definition identifiers.

• SELECT grade_id, grade_definition_id, business_group_id, business_group_name, date_from, date_to, sequence FROM apps.hrfv_grades WHERE business_group_id = :p_bg_id ORDER BY sequence, date_from;

Example: locate a grade by its definition identifier.

• SELECT grade_id, business_group_name, date_from, date_to FROM apps.hrfv_grades WHERE grade_definition_id = :p_grade_definition_id;

Because HRFV_GRADES is a template, production reports that must display flexfield segments should query the generated flexfield views rather than this template directly. HRFV_GRADES remains valuable for understanding the column mapping and base-object relationships underlying grade flexfield views.