Search Results per_cal_scope_values_v




Overview
Explore in AI Chat

Overview

The view APPS.PER_CAL_SCOPE_VALUES_V, titled "View: PER_CAL_SCOPE_VALUES_V," is a reporting and integration construct within the Oracle Human Resources (PER) product family. In Oracle EBS 12.1.1 and 12.2.2, this view exposes the scope and value assignments associated with calendar (PER_CAL) hierarchies, joining generic hierarchy definitions, hierarchy versions, hierarchy nodes, and calendar entry value records. The view carries a VALID status in the APPS schema and is classified as a VIEW object type.

The view is particularly significant in globalization and legislative data contexts, where calendar scope values govern which calendar entries and hierarchy nodes apply to a given business group. By presenting a denormalized, flattened row per hierarchy node together with its current calendar entry value, the view removes the burden of navigating four separate base objects and the HR_CAL_ENTRY_VALUE_API package from report authors.

Underlying Base Objects

PER_CAL_SCOPE_VALUES_V is defined over the following documented base objects: PER_GEN_HIERARCHY, PER_GEN_HIERARCHY_VERSIONS, PER_GEN_HIERARCHY_NODES, and PER_CAL_ENTRY_VALUES (accessed via synonym), together with the package HR_CAL_ENTRY_VALUE_API.

Key Columns

  • HIERARCHY_ID / BUSINESS_GROUP_ID / NAME / TYPE — identify the calendar hierarchy and its owning business group and classification.
  • HIERARCHY_VERSION_ID / VERSION_NUMBER — identify the specific (earliest) hierarchy version.
  • HIERARCHY_NODE_ID / ENTITY_ID / NODE_TYPE / PARENT_HIERARCHY_NODE_ID — describe the node within the hierarchy tree.
  • DISPLAY_VALUE — resolved via HR_CAL_ENTRY_VALUE_API.GET_DISPLAY_VALUE using ENTITY_ID and NODE_TYPE.
  • CAL_ENTRY_VALUE_ID / SELECT_FLAG — the associated entry value identifier and a Y/N flag derived by DECODE.
  • PARENT_ENTRY_VALUE_ID / OVERRIDE_NAME / OVERRIDE_TYPE / USAGE_FLAG — entry-value attributes carried from PER_CAL_ENTRY_VALUES.
  • LEVEL_NUMBER_PATH — the node level path returned by HR_CAL_ENTRY_VALUE_API.GET_NODE_LEVEL, defaulting to '1.' when the node is null.

Common Use Cases and Queries

Typical scenarios include auditing calendar scope assignments, extracting hierarchy structure for integration, and building value-set driven validation reports. A common query retrieves all nodes for a business group:

  • SELECT name, version_number, display_value, select_flag, level_number_path FROM per_cal_scope_values_v WHERE business_group_id = :p_bg_id ORDER BY level_number_path;
  • SELECT hierarchy_id, hierarchy_node_id, entity_id, node_type FROM per_cal_scope_values_v WHERE type LIKE 'PER_CAL%' AND select_flag = 'Y';

Because the view embeds API calls, performance-sensitive extractions should filter on HIERARCHY_ID or BUSINESS_GROUP_ID to limit the row set passed to HR_CAL_ENTRY_VALUE_API.