Search Results normal_start_time




Overview
Explore in AI Chat

Overview

HRFV_POSITIONS is an APPS-owned business view template in the PER (Human Resources) product family, defined for Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to serve as the business view template from which the flexfield view is generated. In practice, this means the view exposes the descriptive and key flexfield context of a position record in a denormalized, report-friendly shape, decoding the underlying POSITION_DEFINITION_ID through the token '_KF:PER:POS:PDEF' and the base table reference '_DF:PER:PER_POSITIONS:POS'. These tokens are placeholders interpreted by the Oracle flexfield view generator, which materializes the position flexfield structure into a queryable column or set of columns at the consumer layer.

For reporting and integration, HRFV_POSITIONS provides a single read-only surface (the definition includes WITH READ ONLY) that joins positions to business groups, organizations, jobs, locations, and replacement positions, and resolves a set of descriptive attributes into human-readable values. Because it is a template rather than a fully materialized view, it is typically used as the basis for a generated business view exposed through the HR Business Intelligence System (HR_BIS) or a customer-built flexfield view.

Underlying Base Objects

The documented base objects referenced by the view are:

  • PER_ALL_POSITIONS (SYNONYM) — the primary position entity, aliased POS, supplying dates, working hours, frequency, probation attributes, normal start/finish times, comments, and the foreign keys to job, location, organization, definition, and relief position.
  • PER_POSITION_DEFINITIONS (SYNONYM) — the position definition header, aliased PDEF, restricted to ENABLED_FLAG = 'Y' and joined on POSITION_DEFINITION_ID.
  • HR_ALL_POSITIONS_F_TL (SYNONYM) — the translated position flexfield definition table, supplying the flexfield context for the generated view.
  • HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM) — used twice (ORGT for the operating organization and BGRT for the business group), both filtered by LANGUAGE = USERENV('LANG').
  • PER_JOBS_TL (SYNONYM) — the translated job name table joined on JOB_ID.
  • HR_LOCATIONS_ALL_TL (SYNONYM) — the translated location table joined on LOCATION_ID using an outer join.
  • HR_BIS (PACKAGE) — the HR Business Intelligence System package, invoked for lookup decoding and business group security.

The replacement position is resolved through a self-outer-join on PER_ALL_POSITIONS (POS1). Security is enforced by the predicate POS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, POS.BUSINESS_GROUP_ID).

Key Columns

Common Use Cases and Queries

Typical uses include position reporting with flexfield description, working-hours analysis, probation tracking, and business-group-secured extracts. A representative query for working hours frequency is:

SELECT hp.position_id,
       hp.organization_name,
       hp.job_name,
       hp.working_hours_amount,
       hp.working_hours_frequency,
       hp.normal_start_time,
       hp.normal_end_time
  FROM apps.hrfv_positions hp
 WHERE NVL(hp.date_to, SYSDATE + 1) > SYSDATE
   AND hp.working_hours_amount IS NOT NULL
 ORDER BY hp.business_group_name, hp.job_name;

Because the view already applies the security profile predicate and language filter, no additional business group restriction is generally required, and the read-only clause guarantees safe, non-mutating reporting access.