Results for “default_start_time”

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

Overview

HRFV_HR_ORGANIZATIONS is an APPS-owned business view template in the Oracle E-Business Suite Human Resources (PER) module. It is defined from which a flexfield view is generated, meaning it serves as a reporting and integration layer that flattens organization definitions, work-day information, and descriptive flexfield data into a single readable structure. The view is marked VALID in ETRM for both 12.1.1 and 12.2.2, and its definition is consistent across these releases. Because it exposes organization attributes such as default start and end times, working hours, and organization type without requiring callers to navigate the underlying HR tables directly, it is frequently used in HR reporting, extracts, and downstream interfaces.

Underlying Base Objects

The view is defined over the following documented base objects: HR_ALL_ORGANIZATION_UNITS (synonym), HR_ALL_ORGANIZATION_UNITS_TL (synonym), HR_BIS (package), HR_LOCATIONS_ALL_TL (synonym), and HR_ORGANIZATION_INFORMATION (synonym). Its SELECT joins HR_ALL_ORGANIZATION_UNITS to its translation table (aliased OT) on ORGANIZATION_ID, constrained to the user session language via USERENV('LANG'). A second alias of the translation table (BGRT) supplies the business group name. HR_ORGANIZATION_INFORMATION is joined twice with outer joins: alias O2 captures the 'WORK DAY INFORMATION' flexfield context, while alias O3 captures the 'CLASS' context, filtered to ORG_INFORMATION1 = 'HR_ORG' and ORG_INFORMATION2 = 'Y' to restrict output to HR organizations. HR_LOCATIONS_ALL_TL is outer-joined for location details, and the HR_BIS package supplies the security profile business group ID and lookup decoding functions. The view is created WITH READ ONLY.

Key Columns

• BUSINESS_GROUP_NAME — name of the business group owning the organization.
• ORGANIZATION_NAME — the organization's translated name.
• DATE_FROM, DATE_TO — effective dating for the organization record.
• DEFAULT_START_TIME, DEFAULT_END_TIME — sourced from ORG_INFORMATION1 and ORG_INFORMATION2 in the 'WORK DAY INFORMATION' context. The searched term default_end_time maps directly to this column.
• WORKING_HOURS_AMOUNT, WORKING_HOURS_FREQUENCY — ORG_INFORMATION3 (converted with TO_NUMBER) and ORG_INFORMATION4.
• INTERNAL_EXTERNAL_FLAG — decoded via HR_BIS.BIS_DECODE_LOOKUP using the INTL_EXTL lookup.
• ORGANIZATION_TYPE — decoded via BIS_DECODE_LOOKUP using ORG_TYPE.
• LOCATION_NAME — location code from HR_LOCATIONS_ALL_TL.
• BUSINESS_GROUP_ID, LOCATION_ID, ORGANIZATION_ID — key identifiers.
• COST_ALLOCATION_KEYFLEX_ID, SOFT_CODING_KEYFLEX_ID — key flexfield references.
• INTERNAL_ADDRESS, COMMENTS — descriptive attributes.

Common Use Cases and Queries

Typical uses include extracting organization work-day defaults, validating flexfield setup, and feeding HR interfaces that require business group and location context. Security is enforced through the NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ...) predicate, so results respect the caller's security profile business group.

To retrieve default work-day times for HR organizations:

• SELECT organization_name, default_start_time, default_end_time, working_hours_amount, working_hours_frequency FROM apps.hrfv_hr_organizations WHERE default_end_time IS NOT NULL;
• SELECT business_group_name, organization_name, organization_type, location_name FROM apps.hrfv_hr_organizations WHERE organization_type = 'HR Organization';

Because the view is read only and relies on translation-language joins, ensure the session language is set correctly before querying to avoid missing translated rows.